how to reduce rows?

[roeireichman]

after i choose employee and year=2019, month= may i get 2 rows

i need to show only 1 row with the last date between them

so in every case i need to reduce the rows and stay with 1 row for each employee 

in this example i need to get only the first record (31/05/2019)

[JordyWegman]

Hi,

You can try to work with Aggr(xxxx, Employee) to get a Max(Date) en leave all the other ones as null. Then reduce the table based on this dimension.

But do you want to have all rows when you don't select anything?

Jordy

Climber

[tomovangel]

Hello Roeireichman

can you replace the max(date) expression with this one:

Firstsortedvalue(date,-date) - this will give you max(date), but sorted through the last date