I have a two lists. One with our Fiscal Year, One with our Calendar Year. We normally view charts in Fiscal Year view. I have a switch that I set/use to bounce between Fiscal or Calendar.
What I want to do is save the value of the Fiscal Year when the user switches to Calendar Year view.
Then reapply the Fiscal Year value when the user switches back to Fiscal Year view.
When I use the Trigger "External/Set Variable" it literally assigns my working variable to the [FISCAL_YEAR] and when the user flips thru Calendar Years my working variable changes with it.
How do I assign the assign the value of my Fiscal Year and have it remain static for later reapplication?
Thanks in advance,
SP
