Here's a good challenge for you all.

Challenge: Filter by 2 colors, then Sort by 'Amount' and not replicate the user's name throughout the Name column?

User Goal: To be able to see which is the lowest amount a user has with a color (or 2 colors).

Imagine you have a table that has 5 User Rows.

The headings for the table are Name - Color - Amount - Cats - Dogs enter image description here

User1, User4 and User5 all have more than one color associated to their row group. So they get a totals row. The others only have 1 color so they don't need a totals row.

Each user has a number of cats or dogs.

You could filter easily on color 'red'. enter image description here

And you can also filter on 2 colors (red and blue): enter image description here

BUT what if.. you wanted to then SORT the Red & Blue filtered results by Amount?: enter image description here

How do you take that Blue 47 out of User 1's group and put it below User4 Red 32 ?? So that it is in Sorted order?

Any suggestions how to make this table better so that it is possible to SORT after Filtering 2 colors and not replicate the user's name throughout the Name column? Maybe there is a better way to lay out this table.

Thank you

  • sorry, but I don't understand the question. I mean: why anyone would do that? All variables belong to user 1, therefore it makes no sense to take the variable outside user 1 domain. Or am I missing something?
    – Devin
    Commented May 26, 2022 at 23:02
  • No worries. I guess if you are sorting on the Amount column, Blue47 for User1 will have to come out and go below User4 Red 32. So that the numbers being sorted are going from low to high (top to bottom). Commented May 27, 2022 at 16:39

1 Answer 1


Firstly, I would change the colours column to fit colors vertical not horizontally.enter image description here

This would allow , for your example : "BUT what if.. you wanted to then SORT the Red & Blue filtered results by Amount?:" to also change the order in table and the order in the colours column.

enter image description here

  • Thank you Chris. The solution is good. I implemented the solution but other, more complex, problems in the table have now become apparent which I need to solve. I might create another challenge and see what you think. Thank you very much for your time and great solution. I wanted to upvote you but the system says I don't have enough power to do that sorry. Commented May 27, 2022 at 15:51
  • Also Chris - I added the Part 2 here - ux.stackexchange.com/questions/143462/… Commented May 27, 2022 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.