Forum Discussion
Previous Period Average Based On Date Range Selection
Hi Everyone, I'm a bit stuck on something. I'm trying to find previous period average sales. This on its own i've been able to do, however, where i'm getting stuck is i need to find average sale...
Hi Anonymous,
You can also take a look at the following blog to use the date function to manually define the filter range to calculate the rolling average:
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng