how to calculate difference between each month data

[Karthick30]

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 )

[Lisa_P]

Use this formula in another measure:

Measure1-above(TOTAL Measure1)