Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am making a pivot table as below: -
I'd like to have the % difference from Nov to Dec infront of December, Dec to Jan infront of January.
The expression I have used to calculate % total is: -
Sum(Total)/sum(total <Month> Total)
something like this.
Sum(Sales)/sum(total <Month> Sales)-Above(Sum(Sales)/sum(total <Month> Sales))
something like this.
Sum(Sales)/sum(total <Month> Sales)-Above(Sum(Sales)/sum(total <Month> Sales))