Set analysis using variables

[#1]

Hi All,

    I have a very minor issue.. I below setanalysis expression is not working.. can some one let me know that the error is?

=sum({< Year= { '$(vMaxyear')}>} Sales)

vMaxYear is the variable which has the value of Maximum year...

Thanks  in advance...

[#2]

Hai Lavanya,

I think there is a small error on the syntax. you have mentioned =sum({< Year= { '$(vMaxyear')}>} Sales)

instead you try =sum({< Year= { '$(vMaxyear)'}>} Sales). I was able to get results with this.

[#3]

Hi Lavanya,

Try this:

sum({< Year= { $(=vMaxyear)}>} Sales)

Regards,

Shyam