Re: Previous Month set analysis not working but with a twist.
Whiteline, unfortunately that did not solve it. This seems so simple, not sure what's causing it not to work.
For the record, this idea comes from Rob Wunderlich. I cannot take credit.
I have my calendar created, then I sort by DateKey and use AutoNumber() to create my serialized values for weeks, months, quarters, etc. Typically it simplifies the rolling forward and back quite well.
AutoNumber(SalesYr & SalesDayOfYr, '_DaySerial') as _SalesDaySerial,
AutoNumber(SalesYr & SalesWk, '_WkSerial') as _SalesWkSerial,
AutoNumber(SalesYr & SalesMth, '_MthSerial') as _SalesMthSerial,
AutoNumber(SalesYr & SalesQtr, '_QtrSerial') as _SalesQtrSerial