Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a PIVOT table for each month. in the same pivot table, as a additional measure, I need to calculate each month difference from previous month. How to find in Pivot table.
so Jan records will not change in my 2 nd measure. for Feb 2023 , 1st record should be -5 ( 1390 -1395) , followed by 3(75-72). .. like wise for for all months ( Mar - feb data ) & ( Apr - Mar data )
Use this formula in another measure:
Measure1-above(TOTAL Measure1)