#1   Report Post  
A Lesner
 
Posts: n/a
Default pivot table - Rank

How do you use the Rank formula in a pivot table
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
A Lesner
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
A Lesner
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I show summary totals from a pivot table on a bar chart Colleen T Charts and Charting in Excel 5 January 22nd 05 02:41 AM
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 03:36 AM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question Barb Reinhardt Charts and Charting in Excel 3 December 8th 04 02:48 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 11:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"