2 of 2 people found this helpful
Do you think the attached workbook works according your expectations?
It uses a calculation with a FIXED Level of Detail calculation to calculate the SUM(Quantity) per Category and per Customer Name, which are used in the view. Because it is a fixed LoD calculation, it can be added as a Context Filter, hence it will take place before the Top 10 filtering of Customers.
Let me know what you think, or in case you need more explanation! You'll find some info on Fixed Level of Detail calculations here: FIXED Level of Detail Expressions
It seems the FIXED Level of Detail calculation does the trick nicely! Many thanks for your help!