- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Multi field slicer with long list of selections options
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 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Do you need any other help on this thread? If not, could you please mark your post as answered? Thank you.
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You could go with two horizontal slicers with single select on. It's probably a lot faster and cleaner considering your use case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you, PANDAmonium. Apologies for my delayed reply.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Do you need any other help on this thread? If not, could you please mark your post as answered? Thank you.
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for letting me know to do that. I have accepted it as solution now.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-25-2024 05:45 AM | |||
Anonymous
| 07-14-2024 05:04 PM | ||
05-11-2024 12:02 AM | |||
Anonymous
| 07-03-2024 03:42 PM | ||
10-01-2024 07:50 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |