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)

      Measure1

      Measure2

       

      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?

       

      Thanks