4 Replies Latest reply: Aug 3, 2018 2:02 PM by Sunny Talwar RSS

    Calculating Percentage change in a pivot table as a field

    Mallika Mhapankar

      Hi Guys, I want to be able to show % change in sales from 2017 to 2018 in a pivot table that looks like this-3.PNG

      So there will be a new column " growth from '17 to '18 " that will reflect the percentage change from 2017 to 2018 for australia, austria , belgium and so on. The first entry will thus be -84% for change in sales in Australia -->  (2018-2017)/2017

       

      Can anyone tell me how the code for this should be?