Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I currently have [Spend] data that I'm wanting to present in a simple table:
Vendor | Selected Year Spend - 2020 | Previous Year Spend - 2019 |
A | 1000 | 1250 |
B | 400 | 500 |
C | 800 | 300 |
How can I create a filter pane that when a user selects 2020 for example all the [Spend] data from 2019 is still available so I can display the previous years result with set analysis.
Much appreciated,
Michael
Dimension: Vendor
Measure 1: Sum({$<Year={$(=Max(Year))}>}Spend)
Measure 2: Sum({$<Year={$(=Max(Year)-1)}>}Spend)
Dimension: Vendor
Measure 1: Sum({$<Year={$(=Max(Year))}>}Spend)
Measure 2: Sum({$<Year={$(=Max(Year)-1)}>}Spend)
Thank you Lisa!
If you have a moment could you explain how the selection works?
Thank you again 🙂
The expressions Max(Year) and Max(Year)-1 are based on the years available/selected, so will dynamically change based on selections. When you want to evaluate the contents of an expression in set analysis you need to put it in a $( ) - Dollar sign expansion.