Current and Previous Year Sales

[#1]

Hello Experts,

I have created two measures:

1. RevCurrentYear with the expression:  Sum({<Year={"$(=getfieldselections( Year))"}>} RowTotal )

2.RevPreviousYear with the expression: Sum({<Year={"$(=getfieldselections( Year)-1)"}>} RowTotal )

The first expression of (RevCurrentYear) works fine but the second one (RevPreviousYear) gives the same result as of RevCurrentYear.

Can you please guide me, what is the problem in second one ?

Thanks & Best Regards,

[vikasmahajan]

attach sample qvw

Vikas

[arulsettu]

try this

Sum({<Year={$(=Max(Year))}>} RowTotal )

Sum({<Year={$(=Max(Year)-1)}>} RowTotal )

[#4]

Thanks for reply Arul, both the expression are giving same result. Does not serve the purpose.

[#5]

Arul, by the way in expression editor the Year color is BLUE. whereas I believe it should be brown ... hope that may be helpful ...

[arulsettu]

can you pose the qvw?

[arulsettu]

it is not the issue. if you give "" it will be brown

Sum({<Year={"$(=Max(Year)-1)"}>} RowTotal )