1 Reply Latest reply on Jun 28, 2016 3:28 AM by John Sobczak

    1 line variance field in pivot

    Paramdeep Khangura

      I have a data set with the following fields:


      Year (2015 and 2016)

      Month (1-12)




      I've created a pivot table where months are columns, then the rows are measure names and then years. Each measure has 2 rows, 1 for 2015 and 2016 (the 2 years in my data set). I simply want to create a third row called variance and it does 2015 vs 2016.

      I've looked at table calculations and difference but this gives me 2 rows and doesn't seem to work in adding a third line in the section.


      Any ideas?