14 Replies Latest reply: Aug 25, 2015 4:55 AM by Digvijay Singh RSS

    Pivot table Calculation Help

    Amit Saini

      Hi Folks ,

       

      I have a pivot table :

       

      Dimmension: STDDATE , Location

       

      Expression : Sum(Values)

       

       

      Requirement : I need to divide "CHESTERFIELD" values with other location row wise.

       

      e.g for STDDATE- 2015-08-17 . the entire row need to be divide by 47 , similarly for 2015-08-18 row should be divided by 46 and so on...

       

      Kindly suggest how this can be achieved .

       

      Thanks,

      AS