COMPARING PERIOD VALUES AND CALCULATING VARIANCES

[#1]

Hi

I have done a pivot table that I populate with "Current Period" and "Previous Period" values, using the following Calculated dimension:

=IF(MATCH(SELECTED_MONTH-PREVIOUS_MONTH,0,1),PREVIOUS_MONTH)

and the following expression:

COUNT

I need to calculate and display the variance between SELECTED_MONTH and PREVIOUS_MONTH as well as the percentage variance.

Would appreciate any assistance.

(Location)

[Anonymous]

think the expression is missing ... :

johanlun wrote:

and the following expression:






COUNT

[#3]

The expression is:

count(source)