Parameter's to filter data across multiple sheets

Q&A
,
1

Hi, I am using parameter to filter data across multiple sheet via control. the date filter only gives me option to select a single date like JAN/2023 and so on. I want to use relative filter so if I select This year, all sheets will be filtered on that control and parameter in the filter. Is this possible?

2

Hi @aahmadd,

You have to create an integer parameter. When you create your relative date filter, e.g. last N years, you then use the parameter to set the value of N.

image