Calculated Field in Pivot

[daveyc18]

column A (date) = Nov 2023 Dec 2023

column B (expenses)

im trying to make a calculated field that takes the difference between the expenses month over month (i have the dates under "columns", expenses under values") instead of using an excel formula in a separate column from the pivot, as it's not "integrated" with the pivot table

 

[bluefish44]

Same issue I have - wondering if this is possible

 

[daveyc18]

Same issue I have - wondering if this is possible

found this but not ideal


drag the expenses field again into the values section. Right-click a value in he PT and choose Show values As \ Difference From...,


base field is date

base item is (previous)