Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to display last 5 years data on chart when user clicks on clear all button
Then use set analysis to define the expressions to include last five years data.
For example:
=sum({<DateID={">=$(=yearstart(today(),-1))"}>}Sales)
Fei