1 Reply Latest reply on Oct 15, 2018 9:08 AM by Deepak Rai

# How can I aggregate a table calculation based calculated fields ?

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%

Manufacturer 2

Manufacturer 3

This should imply that for Manufacturer 1 ,37% of product are in TOP

 Manufacturer Category Sub Category Brand Product Volume Kel C1 SC1 B1 P1 886 Kel C2 SC2 B1 P2 742 GM C3 SC1 B1 P3 62 GM C4 SC2 B2 P4 746 Chob C2 SC3 B2 P5 690 Chob C1 SC1 B2 P6 589 Chob C1 SC3 B3 P7 865 GM C1 SC2 B3 P8 273 Kel C4 SC1 B3 P9 266

Problem I am facing is that I cannot aggregate table calculation at different levels ,