Tableau incorrect average field value on drill up level

Question

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

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

Any suggestion?

Answer 1

Try

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