I want to find the first occurrence of data and use it to apply the row filter condition.
I have a table with a user ID, team, cost, and balance. I want to filter rows to only show where first appear in the team column.
I have tried using lookup to get the row number of the particular row but it doesn't work.
The above is without applying any row filters. Since all the rows have the same pending sum I want to show only the first occurrence of it.
You can try to set the following to a slice filter..
[key col] = MINROW("table name", "_RowNumber", [col to search for 1st occurrence] = [_THISROW].[col to search for 1st occurrence)
How would I apply this in the row filter condition if I want to find the key col for 9 different team name occurrences? These are teams:
Admin |
Team 1 |
Team 2 |
Team 3 |
Team 4 |
Team 5 |
Team 6 |
Team DXB |
Teamless |
they are automatically identified by the expression. No need to specify specific names.
User | Count |
---|---|
26 | |
25 | |
25 | |
20 | |
19 |