Hi - I've looked for a solution everywhere but couldn't find anything so I am posting here.
I am importing some data from Access to Excel and using a pivot table / chart to summarize it. I'd like to set up the pivot table in a way that allows me to create a slicer for the top 5,10, and 15 items by sum of amounts. Once I set up the fields (rows: item; values: amounts), I know how to change the amounts field settings to that it shows me the rank of the items instead of the actual total amounts. This doesn't help, though. I cannot insert a slicer based on the rank - it always shows the amounts; also - it doesn't let me group the ranked field as it represents values.
Here's how the pivot table is set up (please also see the attached file):
Item Rank Sum of Amount
A 7 296233
B 3 457870
C 2 468153
D 13 168286
E 23 10337
F 21 56430
H 6 301803
I 11 191416
J 15 132950
K 1 632375
L 10 213351
M 19 77899
O 17 90044
P 14 165690
Q 9 225537
R 18 78537
S 12 188442
T 5 334858
V 16 122488
W 22 37713
X 8 228884
Y 4 338451
Z 20 70874
I want a slicer with three slicer items: 5, 10, and 15, representing the top 5,10, and 15 pivot table items based on the sum of amounts. Is this possible with a pivot table? Please see the attached file.
Thanks a lot.
D.
Bookmarks