Let's imagine a table structured like this:
| Bucket | Red | Blue | Green |
|---|---|---|---|
| First | 1 | 3 | 4 |
| Second | 6 | 5 | 2 |
What I'm trying to achieve is based on the values within each bucket, I'd like to generate another set of fields with the highest ranking, second highest ranking, and third highest ranking colors (assume there are more than three colors as well). We are limiting to top 3.
Essentially, what my final output should look like is this:
| Bucket | Red | Blue | Green | Rank 1 | Rank 2 | Rank 3 |
|---|---|---|---|---|---|---|
| First | 1 | 3 | 4 | Green | Blue | Red |
| Second | 6 | 5 | 2 | Red | Blue | Green |
Hoping this isn't a redundant question.
