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

Calculating a percentage change between two numbers in a pivot table

Capture.JPG

How do I calculate the percentage change between the totals and by each territory? So for example (126-140)/140=-10.00%

Thanks

1 Reply
sunny_talwar

May be try this

Count(Measure)/Before(Count(Measure)) - 1