Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I created a table with Name as dimension, and the Status us a measure with this formula '=FirstSortedValue(DISTINCT Status, -Date)'
Name | Status |
RefA | Completed |
RefB | Pending |
RefC | Removed |
How can I make that measure (resulting Status column) to be able to filter (magnifying glass) on the table?
@ynottableau Could you please use the below expression in your Dimension:
Aggr(FirstSortedValue(Status, -Date),Name)
If this resolves the issue, please like and accept it as a solution.
@ynottableau Could you please use the below expression in your Dimension:
Aggr(FirstSortedValue(Status, -Date),Name)
If this resolves the issue, please like and accept it as a solution.