4 Replies Latest reply: Jul 23, 2013 3:53 AM by Bikash S RSS

    Pivot Table - Calculate Percentages

    Paul Edrich

      Hi and thank you in advance..

       

       

      I have a Pivot table which is calculated from the load script with a cumulative last day of the month value Flag -  I want to calculate % +or-.

       

       

      EG...

       

       

      Regions                     Sales 1     Sales 2     % +/-

      Region 1                    100          90                    ?

      Region 2                    200          210                   ?    

      Region 3                    150          131                    ?

       

      Should this be done in the load script (If so how)?

       

      Or

       

      Better as an expression calculation!

       

      I have explored Column (1) / Column (2) - with no result.