Hello everyone.
I need your help, I have question about How to use LOD to calculate some value according to previous value from filter.
1. My Data Source from Excel
2. I create calculation field for previous year
3. I use LOD and use [Previous Year] to filter with LOD
4. I want column [Previous Year Calculation] to show the value of 2018 (The value of Previous Year) when I select filter for 2019
How to get the value of previous year from selected filter ?
Hi, Tee
In this case, you need two parameters, one for year selector, and the other one to control whether use the year selector or by default which it is the latest year as current year.
Below is the result of by default
and when activate the custom year selector,
I just add two more lines in your data for a better sample
Workbook attached .hope this helps
ZZ
