I have a data source something like this, My need is to divide all products in three buckets of Top, Middle ,Bottom based on there Volume .
So lets say for any category there are 9 products 3 of them should be in top,3 in middle and 3 in bottom.
I was able to achieve this by using TABLE CALCULATION , however I also want this two be aggregated at various level like Manufactrer, Brand etc.
So my aggregated view will be something like this
TOP MIDDLE BOTTOM
Manufacturer 1 37% 23% 40%
This should imply that for Manufacturer 1 ,37% of product are in TOP
Problem I am facing is that I cannot aggregate table calculation at different levels ,
Please attach a workbook to help you.