Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have to use an expression like:
Sum({<year ={"<$(=Max(Year))" }>}Amount)
But I want this in filter-pane
Filter pane can not consider measures
Yes, but a filter filters a dimension/measure so it is the same right?