Hello @A_Darcy ,   What version are you using? I tried to recreate your issue with VA8.5 and below is the Crosstab I got. Is this different from yours? In your source data does the Date variable still have September even though Sales doesn't have value in it?     Actual YTD (€) = CumulativePeriod(_Sum_, 'Sales_missing'n, _IgnoreAllTimeFrameFilters_, 'Date'n, _Inferred_, _ByYear_, 0, 1, _Full_, {Date})   I have attached the data I used.   Best regards, Petri ... View more