Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to calculate how units have been sold in the follow based on calculating against today's date:
*Last 30 days
*Last 60 days
*Last 12 months
*YTD
Help would be greatly appreciated.
Hi.
To calculate separate values set analysis + data flags approach is usually preferable.
To calculate cumulative and rolling sums in time you could use asoftable approach.
Calendar with flags making set analysis so very simple
Calculating rolling n-period totals, averages or other aggregations