Im currently trying to compare 2 years among 3 years information is available.
For example, i got information from 2014,2015 and 2016. And i got 2 main columns, that one displays the information from a year and another from another year.
What im trying to do, is put on the first column the Min(Year) available, and Max(Year) on the second column.
In this case, if nothing is selected the first column would have the information from 2014 and the last from 2016. If you select 2014 and 2015, the first one remains with 2014, but the second one changes to 2015.
Im currently trying something like this
sum({$<Year={"=$(=Min(Year))"}>}amount) and sum({$<Year={"=$(=Max(Year))"}>}amount)
The problem is this doesn't seam to matter, since is the same result if i used sum(amount). Can anyone help me with the proper way to do thius?
