add calcuated column in pivot table

[adamjwchen]

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?

[devarasu07]

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)

[tresesco]

May be like this?