Show first unique row of a filtered table

1

Hello,

I have been searching for hours and haven’t come up with a solution for my problem. I have a table that i have filtered and sorted. I would now like to show only one of each Category based on the highest Value. An example is below

Category Colour Value
Spring Yellow 7
Winter Green 7
Summer Blue 6
Spring Red 5
Winter Yellow 4
Fall Purple 2

and I would like to show:

Category Colour Value
Spring Yellow 7
Winter Green 7
Summer Blue 6
Fall Purple 2

Any suggestions would be appreciated.

Thank you

2

OK… so I managed to do what i wanted. I’m sure there is an easier way, but for anyone coming across this post see below:

if(thisTable.Filter(Season=thisRow.Season and thisTable.[Value].max()=thisRow.[Value],“Yes”,“No”)

Basically created a row to check if the value is the max value for that each season. If it is, then a yes appears for that row, if not a no. I then filter that column to show only rows that contain “Yes”. This elminates all extra rows and leaves the 4 season rows with the highest values.

1 Like
3

Hey @Kyle_McDowell - Thanks for coming back to share your solution with the community! It’s appreciated and very helpful. Cheers!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.