Hi, We have a cross table that can be drilled down and it has the Sales value for the month and the Actual YTD for the monthly cumulative. However, in Sept there was no Sales, and so no entry for that month. So it’s not showing an Actual YTD for that month either then, in other words September doesn't appear in the table. Formula for Actual YTD (€) is CumulativePeriod(_Sum_, Sales,_IgnoreAllTimeFrameFilters_, 'Date'n, _Inferred_, _ByYear_, 0, 1,_Full_, {Date}) Can we adjust the formula to force an entry for September even is there is no Sales data for that month? Regards, Aoife.
... View more