Hello community :)
I have a dimension with all my employee and their packages (with historization). For example: one personn who received a salary increase have 2 rows:
- first row with start end date of previous package
- second row with start date as end date of the previous package
Would it be possible to create a formula which allows to have a filter in page which ables to select only the last value in the dimension for each employee (ie the last up to date package)?
Thanks a lot!