5 Replies Latest reply: Apr 9, 2018 8:18 AM by vishal raina RSS

    Aggregation Table

    vishal raina

      Hi Community members,

       

      Need urgent help on the below.

       

      I have to create a table in which i need division of some aggregated columns.

       

       

      ProductMetricFrontBackSide
      1aSales5254.52456.5714292017.928571
      2aInc260.39%121.74%100.00%

       

      The ask :

      We have 2 dimensions - one is the Product (a) and the other being the product position (front, back , side)

      I have the sum of sales for the product "a" over the product positions(front, back , side) as given in row 1.

      I want to find out the percentage as in row 2 which is sales /min(sales) for each cell. Denominator would be Min sales value across product positions per product (from row 1) and the respective sum of sales would be the numerator.


      Ex. 260.39% =5254.5/2017.92, 2017.92 being the min sales.

      Note : Table format isn't imp, just need a way to form a similar value table.