Macro for selecting year

[johanlind]

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

How do I write the macro ?

[gandalfgray]

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)