Filter Issue while using ABOVE Function

[elie_issa]

hi all,

Please i am having problem with the below expression while filtering on a specific business unit

above(FirstSortedValue(distinct [Business Unit],-[Assignment SDate]))

This expression is working fine in case we are not filtering any business unit.

The purpose of my expression is to get the previous business unit.

Any idea how to solve this issue.

Thanks.

[OmarBenSalem · Accepted solution]

This is what I have :

Last : =aggr(FirstSortedValue({< BusinessUnit>}distinct BusinessUnit,-AssignementDate),EmployeeNumber)

Before Last : aggr( above(FirstSortedValue({< BusinessUnit>}distinct BusinessUnit,-AssignementDate)) ,EmployeeNumber,AssignementDate)

If I select SCTT :

[elie_issa]

it's working fine. thanks a lot for your effort.

The only problem for me now is in the security.

[OmarBenSalem]

For that, creating a table with Last and Before in the script would be a better approach I think.

Don't forget to mark the helpful and correct answers as so.

Have a nice day