How to Calculate Cumulative YTD

[Purushothaman]

Hi There,

For the Below dataset:

How to calculate cumulative YTD 

Below is the expression for my YTD and Variable expression:

YTD Expression:

NUM(SUM({<L2-={'TOTAL'},[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset,Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},
[Year Month Base (YYYYMM)]={">=$(=($(vYTDMin)))<=$(=$(vYTDMax))"}>}VV/$(pSwt_Unit)),'#,##0')

vYTDMin
Date(YearStart(max({<"Year_Offset"={0},"Year Month_Offset"={0},"Year Quarter Offset"={0},"Year half year offset"={0}>}PERIOD_FACT),0),'YYYYMM')

vYTDMax
Date(max({<"Year_Offset"={0},"Year Month_Offset"={0},"Year Quarter Offset"={0},"Year half year offset"={0}>}PERIOD_FACT),'YYYYMM')