Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any suggestions? I’ve searched on rolling month here, and see a lot of answers about how to use it in a calculated expression, but nothing quite like I want to do. I'm sure there's got to be a simple solution to this but I haven't been able to work it out.
I have a month field, which is a list box on my sheet. When a user selects a month, I want all of my charts with month as a dimension to show the selected month and the 5 months prior.
Ex: Selecting 2011/05, should cause my charts to show:
Month Expression Value
2010/12 5
2011/01 7
2011/02 6
2011/03 6.5
2011/04 7
2011/05 4
I’m attaching a sample QVD. Any help with this would be much appreciated!
This would be helpful!
I use variable to do this.
This worked for what I need - thanks!