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]

Use below expression, instead of creating Flag in script

Sum({<Period1={">=$(=Yearstart(today(),0,4))<=$(=max(Period1))"},Year,MonthYear>}Leavers)