How do we calculate ytd monthly totals that don't inflate the quarter and FY totals?
We want to see YTD monthly and YTD quarterly as well as the total FY. Currently when we use YTD the quarters and FY totals are overstated.
For instance in September the quarter total shows Jul-Sept, but the quarter total is double counted. The time selection we have set in the model is quarter totals and YTD summary and the module line items are set to month.
Thanks for your help.