I’m having a total brain fart kind of moment.
I am trying to create a BAQ that shows the year and month in columns starting from current month and going backward by part number. My fourth column should show the rolling 12 month average of sales for a given part number. Ideally, I’d end up with something like this. Any suggestions?
You absolutely nailed it. Once I got the Fiscal Period table idea, the other pieces fit together perfectly. This is going to make a beautiful chart in a dashboard.