[rsm_ryan_meyer]

I am working with a client who would like to see a rolling 12 month Trial Balance. The Last Rolling Year Alternate Date Range works nearly perfectly for this.

I say “nearly” because the ordering seems backwards. The default puts the oldest month first. For instance when I run it as of today, May 2014 is first, then June 2014, then July 2014…and finally April 2015. Is there a way to reverse the ordering so that April 2015 is first, then March 2015…finally May 2014?

This seems to be the case anywhere a “rolling” date range is used. Is there any way around this? Most users I’ve dealt with want the most recent month first. Thanks.
This is a cached copy. Click here to see the original post.

[shayanzia]

Hi,

Was just going through your post and saw that you had mentioned “Last Rolling Year” Alternate Date Range. When I run the Trial Balance in the hope to see it for the last 12 months, I don’t see such an option in the Alternate Date Range field. Can you please guide me how to access this particular option? Thanks!

---

shayanzia replied on 10/30/2015, 02:53 PM: rnedelkow Thanks for the info! But I know how to add time-based comparison columns to reports. However, my issue is that in the Alternate Date Range field, I don’t see the option for “Last Rolling Year”. There is an option for “Last Rolling 6 Quarters” or “Last Rolling 18 months” but none for the last 12 months.

[Author]

Posts