Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
siewmei_lsm
Contributor II
Contributor II

How to calculate changes between 2 date for a measure in pivot table

How to calculate the changes for 1 measure between 2 date in pivot table?

if  there are 2 measure i can easily use formula column 2-column 1 but for my case is only have 1 measure, and need to calculate the different between 2 date.

Capture.PNG

1 Solution

Accepted Solutions
sunny_talwar

May be one of these

Expression - After(Expression)

or

Expression - Before(Expression)

or

After(Expression) - Expression

or

Before(Expression) - Expression

Replace Expression with whatever expression you have in your chart

View solution in original post

1 Reply
sunny_talwar

May be one of these

Expression - After(Expression)

or

Expression - Before(Expression)

or

After(Expression) - Expression

or

Before(Expression) - Expression

Replace Expression with whatever expression you have in your chart