Is there a way if the filters are set to a default value and I want to automate them so that when a quarter ends, the filter's default value changes itself without any manual effort, is it possible? (Example: when Q1 ends Q2 becomes the default value)

Hi there,

You can create a parameter filter with quarters Q1, Q2, Q3, Q4. (Parameter Quarter) which should have the feed from a Quarte calculation when the document opens.

Create a calculated field (ex. Value_Column) which will identify which one should be the quarter (based on your value).

Make sure the default value = Value_Column.

So, basically you're feeding the quarters to a parameter and used default value a calculation.

this is the tutorial you need.

thanks

Adrian