Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a dimension 'Year' and I only want to show three years as default , I have remaining years in the filter, the user can choose more years from .
Please help.
As below
=Aggr(only({<Year={">=max(Year)-3"}>} Year),Year)
Hi, you can create 'default' bookmark with manually selected or selected dynamically years, like
{<[Year]={"=[Year]>=year(today())-2"}>}
and make that bookmark as default, so whenever you open app, year filter will be applied, but other values also can be filtered.