Tableau incorrect average field value on drill up level

user_3109946 0
Viewed 28

I am very much new for tableau and working on a report in tableau with two level drill-down. I have three fields named 'Sales' and 'Quantity' and 'Avg-Price'. I need the correct value of 'Avg-Price' (?) when I drill-up on company level. See below picture

enter image description here

For field 'Avg-Price', I use 'CalculatedField' with formula '[Sales]/[Quanity]'.

Any suggestion?

drilldown tableau-desktop
1 Answers

Try

SUM([Sales]) / SUM([Quantity])
user_4419790
Related