Afternoon team, hope you're all well and happy friday.
Quick query I hope
I've attached an example qvw, where I'm trying to achieve a rolling 12 month total when you select a month.
As per my attached, currently if you select say 2018 Nov, this will then change the bar chat to show 2018 Nov and the previous 11 individual month totals. So as a month calculation, this works perfect to show each individual month across the last 12 months.
However, i'm a little stuck as to how I can have each one of those 12 categories, showing a 12 month total.
For example select 2018 Nov, this will show data between 2018 Nov - 2017 Dec (12 month total)
Then the category next to it being 2018 Oct, will show data between 2018 Oct - 2017 Nov and so on.
Hope this makes sense and can help me piece this together