I'm generating a table that calculates an estimated commission for each sales rep (who's 1 of approx 30 sales reps on the sales team)
The sales reps estimated commission, per product (of which there are 5) is driven off of how their total sales (per quarter) rank in comparison to total sales of all the other reps.
I created a slicer that has two fields: Product and Rank: all of the following appears in one slicer... where, for each product... the sales reps enters what they think their rank will be by the end of the quarter; so they can do a what-if analysis. Since, for each of the 5 products, the sales rep has to select a rank of 1-30, the slicer expands and become very long. Does anyone have any idea or suggestion they can share on how a slicer can accomplish the same thing- allowing the user to select a rank for each of the 5 products- that is a better user experience? Thanks!
| Product | Rank |
| Product 1 | 1 |
| | 2 |
| | 3 |
| | 4 |
| | 5 |
| | 6 |
| | 7 |
| | 8 |
| | 9 |
| | 10 |
| | 11 |
| | 12 |
| | 13 |
| | 14 |
| | 15 |
| | 16 |
| | 17 |
| | 18 |
| | 19 |
| | 20 |
| | 21 |
| | 22 |
| | 23 |
| | 24 |
| | 25 |
| | 26 |
| | 27 |
| | 28 |
| | 29 |
| | 30 |
| Product 2 | 1 |
| | 2 |
| | 3 |
| | 4 |
| | 5 |
| | 6 |
| | 7 |
| | 8 |
| | 9 |
| | 10 |
| | 11 |
| | 12 |
| | 13 |
| | 14 |
| | 15 |
| | 16 |
| | 17 |
| | 18 |
| | 19 |
| | 20 |
| | 21 |
| | 22 |
| | 23 |
| | 24 |
| | 25 |
| | 26 |
| | 27 |
| | 28 |
| | 29 |
| | 30 |
