Rank with a Filter (table calculation)

[dkennedy2-16515]

I have a list of SKUs, the Product Category each SKU belongs in, and each SKU’s Order Count. I’d like to make a visualization that shows only the top selling (highest # orders) SKU in each of the categories.

In Google Sheets, I’d go about this with =RANK(FILTER) formula. I’d rank the Orders column and filter on the Product Category column. I have not been able to replicate this in Looker. Any advice on how to rank with a filter in Looker?

I do not have LookerML access and need to accomplish this using table calculations. I’m open to using other formulas within table calculations if better.