Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table - Rank
How do you use the Rank formula in a pivot table
|
#2
|
|||
|
|||
Hi
AFAIK you can't -- Regards Frank Kabel Frankfurt, Germany "A Lesner" <A schrieb im Newsbeitrag ... How do you use the Rank formula in a pivot table |
#3
|
|||
|
|||
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. "Frank Kabel" wrote: Hi AFAIK you can't -- Regards Frank Kabel Frankfurt, Germany "A Lesner" <A schrieb im Newsbeitrag ... How do you use the Rank formula in a pivot table |
#4
|
|||
|
|||
Hi
you can sort the values -- Regards Frank Kabel Frankfurt, Germany "A Lesner" schrieb im Newsbeitrag ... 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. "Frank Kabel" wrote: Hi AFAIK you can't -- Regards Frank Kabel Frankfurt, Germany "A Lesner" <A schrieb im Newsbeitrag ... How do you use the Rank formula in a pivot table |
#5
|
|||
|
|||
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 "Frank Kabel" wrote: Hi you can sort the values -- Regards Frank Kabel Frankfurt, Germany "A Lesner" schrieb im Newsbeitrag ... 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. "Frank Kabel" wrote: Hi AFAIK you can't -- Regards Frank Kabel Frankfurt, Germany "A Lesner" <A schrieb im Newsbeitrag ... How do you use the Rank formula in a pivot table |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |