Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table as below. Dimension(Year) is manipulated, I would like to get the variance column, can someone get me some hints?
Hi,
Try like this,
Variance:
sum(Amount) - before(sum(Amount))
or other way,
Create Measure like below,
=Max(Year) // current year
sum( {$<Year={"$(=max(Year))"}>} Amount)
=max(Year)-1 // previous year
sum( {$<Year={"$(=max(Year)-1)"}>} Amount)
Variance:
Column(1)-Column(2)
May be like this?