Sales data only less than current month

[ajsjoshua]

Dear all,

I have sales data for 5 years 2013 to 2018.

Now i want to show sum(Sales) only for the years 2015,2016,2017 and for months less than current month

since the current month is August

i want to show sum of sales of 2015(Jan to July),2016(Jan to July),2017(Jan to July)

Regards,

Joshua.

[ValeriyaBartosh]

hello,

you can create flag

and then use this field in set analysis sum({<flag={'1'}>}Sales)

[andrey_krylov]

Maybe just select months and years in listboxes...

[ValeriyaBartosh]

точняк)

[andrey_krylov]