vV_CurrentYear = Year(Today()) so the chart is currently defaults to the current year.
However, we'd also like to enable the users to select other year from the 'Year' filter pane. Please note, they can only select one single year from the filter but not multiple years.
Please let me know how to achieve this via set analysis.
Yes, it's a bit if a trick that it works. What you really want is the max JDE.Year but no later than today. When nothing or more than 1 JDE.Year is selected, [JDE.Year] is returning null because there is only one value. So it uses today().
It will however break if more than one JDE.Year is selected. It actually should have a max() in there:
[JDE.Year] = {$(=max(Year))} works great and it shows the data for the year I selected too.
However, is there anyway I can still use {$(=$(vV_CurrentYear))} to load the initial data with current year data. Then once user select the year from the filter pane, it will overwrite the current year data.
sum({<[Ledger Type]={'BA'} ,Source={'F0902'} ,[JDE.Year] = {$(=$(vV_CurrentYear))} // Any way to add [JDE.Year] = {$(=max(Year))} here to overwrite the initial load of current year data if user select another year? >}Amount/100)
The thing is if I only use [JDE.Year] = {$(=max(Year))}, the dashboard shows 0 when it initially loads. Users need to select the year from the filter pane in order to show the data.
Basically I want the dashboard to initially load current year data based on {$(=$(vV_CurrentYear))} but user able to switch to other year based on {$(=max(Year))}. Does that make sense?
