How to Achieve this

[gautik92]

I am attaching files

if yu see the qvw file I am calculating YTD in script for month wise.that is working fine. but if I take age as dimension it is not working

its showing wrong values.

any ideas

thanks in advance

[Kushal_Chawda]

Create YTD Flag like this

Data:

LOAD *,

           YearToDate(Period1,0,4)*-1 as Flag

FROM table;

Now use expression like below

=sum({<Flag={1}>} Value)

[gautik92]

will it work if I select a month

[gautik92]

Supppose if I select July 2017 it shud show value summing up from April 2017 to July 2017

[Kushal_Chawda]

Yes. It will work

Data:

LOAD *,

            monthname(Period1) as MonthYear,

           YearToDate(Period1,0,4)*-1 as Flag

FROM table;

[Kushal_Chawda]

But why you want Apr 17 to Jul 17 when jul 17 is selected, it should ideally display only Jul 17 no?

[gautik92]

yes if I select july 17 it shud sum up value from apr 17 to till date and show

[Kushal_Chawda]

You can exclude the selection of your other periods for YTD,

Data:

LOAD *,

            monthname(Period1) as MonthYear,

           YearToDate(Period1,0,4)*-1 as Flag

FROM table;

expression

Sum({<Flag={1},MonthYear>}Leavers)

[gautik92]

this is not working

[vinieme12]

See this post

The As-Of Table

Calculating rolling n-period totals, averages or other aggregations