7 Replies Latest reply: Sep 26, 2017 11:34 AM by Sunny Talwar RSS

    How to Create a % Change ROW in a Pivot table

    Jason Campbell

      I need to create a row that displays the 2016 vs. 2017, % Change, by month.  I can calculate the % Change and put it in a column all day long, but do not know how to make it a row (for each Metric). 

       

      Here is a sample of what I need.  I have the pivot table created, just need the % Change row in bold.  What would be the best way to go about this?

       

      Capture.PNG

       

      Thanks in advance,

      Jason