A
A Lesner
How do you use the Rank formula in a pivot table
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
AFAIK you can't
AFAIK you can't
A
A Lesner
Is there a workaround for ranking in a pivot table? It seems that if a
pivot table can not rank, it severly limits it's use in the business world.
pivot table can not rank, it severly limits it's use in the business world.
F
Frank Kabel
Hi
you can sort the values
you can sort the values
A
A Lesner
I need a pivot table to rank fields. I need it in a pivot table because this
is applied at salesperson level, region level and national level.
Sales CUV % Rank CSI Rank
Tracie 68.0% 5 90.8% 4
Becky 125.0% 1 90.8% 4
Jennifer 88.0% 4 91.5% 1
Bob 108.0% 3 88.3% 6
Brad 45.0% 6 91.5% 1
Chuck 125.0% 1 91.0% 3
is applied at salesperson level, region level and national level.
Sales CUV % Rank CSI Rank
Tracie 68.0% 5 90.8% 4
Becky 125.0% 1 90.8% 4
Jennifer 88.0% 4 91.5% 1
Bob 108.0% 3 88.3% 6
Brad 45.0% 6 91.5% 1
Chuck 125.0% 1 91.0% 3