I need to calculate the firstValue in my data source PRE_FILTER.
I can get the firstValue function to work but need to avoid the value changing once table filters are applied.
As far as I’m aware, I can’t use the level-aware PRE_FILTER with firstValue.
In my specific example, I’m trying to return the first team (string) for each person (string) ordered alphabetically.
firstValue(team,[team ASC],[name])
Any thoughts or workarounds?