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 .