Macro for selecting year

johanlind — Mon, 15 Nov 2010 11:00:36 GMT

I want to write a macro for selecting this year and previous year, when the data is reloaded.

How do I write the macro ?

SV:Macro for selecting year

gandalfgray — Mon, 15 Nov 2010 15:02:33 GMT

I would create an OnPostReload Trigger with a Selection Action, like this:

To get it dynamic create a variable CurrentYear which you sets to the current year in the load script,

and change the Search String shown above to this instead:

='>=' & ($(CurrentYear)-1) & ' <=' & $(CurrentYear)