How to add filter only 2013 and 2014 from Sum( {$<IsInYTD={1}>} sales )

[#1]

Hi All

May i know how to modify the expression to remove 2012 ? my expression is shown above ,

[#2]

Sum({<IsInYTD={'2013','2014}>}sales)

[tresesco]

Try like:

Sum({<IsInYTD={1}, year -={2012}> sales)

[SunilChauhan]

Sum({<isinYTD={1},Year-={$(=Year(today())-2)}>} Sales)

it will be Dynamic. when you move next Year i.e 2015 and want data of 2014 and 2015

then it will auto make changes not need to right 2012 ,2013 to exclude.

hope this make sense

[rustyfishbones]

You can try

Sum({<IsInYTD={1}, year -={$(=MIN(Year))}> sales)

which means it will always disregard the earliest Year

Regards

Alan

[#6]

Hi All

Thank you for your reply. but all not able to work. enclosed my QV doc.

[rustyfishbones]

It does work if you use

Sum({<IsInYTD={1}, year -={2012}>} sales)

as tresesco said above

[#8]

Hi Alan

Can you send back the file to me , as i am using ver 9 , and still not able to see it work like your attach chart.

Paul

[ashwanin]

Use formula

=sum({$<Year ={">=2013"}>}IsInYTD)

I have implemented it in qv graph attached.

[tresesco]

Paul,

Correct the curly brace and it will work in V9 also.

=Sum({<IsInYTD={1}, year -={2012}> } sales)