Prior Year YTD total option for Time Ranges

Andrew_Paston

Hi, We have a large reporting requirement for reporting versus prior year for reporting month and Year to date. 

 

The month is easily achievable but if we want to create views that compare Prior year to date versus current year to date its a lot more fiddly. Alot of our monthly reporting is done through the Excel Add in and dashboards.

 

To get Prior year YTD we either currently create seperate modules in Anaplan using subsets and OFFSET formulas etc. 

 

It would certainly be alot easier if we had an option to add the Prior year YTD to a timescale or time range rather than have to export different modules via the add in that have the correct prior YTD totals 

Interested to know whether anyone else would support this.

Thanks

Andrew 

Andrew_Paston

.

PaulCooper

Would absolutely support this. Doing YTD vs Prior YTD should be easy, but it's currently extremely complicated.