Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Madhu8523
Contributor
Contributor

FILTER PANE AUTOMATIC SELECTIONS

We are using retail dashboard 

in the dashboard we have one year dimension in filter pane 

so in that filter pane we have 1989 to 2023 years are there

so suppose assume when I select the year 2015 the filter pane will automatically selecting the previous year’s 

ex:: 2015 to 1989

suppose if I select the year 1995 it will selecting the years

1995 to 1989 

so this is the requirement 

Labels (1)
3 Replies
JHuis
Creator III
Creator III

You have to use an expression like:

Sum({<year ={"<$(=Max(Year))" }>}Amount)

Madhu8523
Contributor
Contributor
Author

But I want this in filter-pane

Filter pane can not consider measures

JHuis
Creator III
Creator III

Yes, but a filter filters a dimension/measure so it is the same right?