Re: How to replace the current month variable with any month I select?
Thanks Guzman, that worked great. But one thing broke.
I have a second variable for the vPrevMonth to store the prior month which I have now set a second action on max(F1) -1
I have numbers for the months from the start of our calendar so -1 will always work and it does.
This month is 50 and my variable, when I click on Feb, does make the vPrevMonth = 49.
But it seems that my set analysis using the vPrevMonth does not work any longer. My fear is that when I select my month it now has the month as the current selection and thus drops the prior month I wish to display as well.
In a nutshell I want to take this further where when a month is selected, the previous changes and is not limited by the selection.