Before I log my problem I’d just like to thank Sam for an awesome service. Registered and paid a short while ago and the whole site is so inspiring and helpful. Anyhow back the confusion of a newbie.
I am scoping out a financial report using David Churchwards Cascading subtotal pattern.
That is all working fine. I have date filter linked to the calendar table and getting MTD YTD etc all working brilliantly from a single month year selection.
Two questions -
- How can we get a 12m actual history graph, - previous 12 m from selected single month date. So if Nov 2018 selected - x axis will be Dec 17 to Nov 17 with each month
- Having achieved that how do we put another line on it with the previous 12 months rolling total.
So Nov will have Dec to Nov actual; Oct will have Nov - Oct actual etc.
I have googled this one till I’m blue in the face and I understand David Churchwards idea of using a detached date table. But then other time intelligence seem to fail and there has to a way to do this with the proper calendar table. I’ve tried various combinations of ALL but I just can’t see it!!!
PS still awesome site