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
Have you tried the below with the Table Calc being partitioned by month and addressing by year?
If last()=0 then SUM([Measure1])-Lookup(sum([Measure1])-1) end