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

    How can I aggregate a table calculation based calculated fields ?

    Pallav Abhishek

        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

       

        

      ManufacturerCategorySub CategoryBrandProductVolume
      KelC1SC1B1P1886
      KelC2SC2B1P2742
      GMC3SC1B1P362
      GMC4SC2B2P4746
      ChobC2SC3B2P5690
      ChobC1SC1B2P6589
      ChobC1SC3B3P7865
      GMC1SC2B3P8273
      KelC4SC1B3P9266

       

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