set analysis

[Anonymous]

i want to compare current selection vs previous selection for budget rev.

I have declared 2 variables 1.vCurryear=max(year) other vPrevyear=vCurryear-1

Within one expression curr budget rev i have written the following -

Sum({$<Year = {$(vCurryear) ))}>} [Budget rev#]

why data is not coming?

should i declare another expression for other year?

i want to compare current vs previous year

[Anonymous · Accepted solution]

There are some mistypigs here... Try this:

Sum({$<Year = {$(vCurryear)}>} [Budget rev#])

[Anonymous]

Hi I have resolved this .Your answer also correct.

sum({$<Year={$(=vPrevyear)}>} [Budget rev#])

Regards