Hoping someone can help me with this,
I have a table with a list of brands and a score for each brand. The brands are labelled by category, some brands have multiple categories. I want to be able to automatically rank these brands by their score, and have that rank update if I filter.
E.g if I filtered to just 'makeup' the rank would update to only rank the brands categorised as makeup.
Included an example table that's simplified,
Hoping this is possible!
Thanks in advance,