Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
May i know how to modify the expression to remove 2012 ? my expression is shown above ,
Also if you want to check the sum of Sales, then replace IsinYTD with sales in Expression
i.e use =sum({$<Year ={">=2013"}>} sales)
Here it is, however, the next time you upload the qvw, you should try to reduce the data to make the file smaller in size.
See the attached file
Regards
Alan
Hi All Thank you for all the reply.
Finally , i need to combine tres and Ashwani :-
=Sum({<IsInYTD={1}, year ={">=2013"}> } sales)
and it work for me.. but not dynamic and yearly need maintenance.
So i modify with sunil code like below , but not able to work , Does any one know how to make it work ?
=Sum({<IsInYTD={1}, Year={$(=year(today())-2)> } sales)
Paul
you can try this
This?
=Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> } sales)
Be careful about brackets.
finally this is what i look for. thank tres.