Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank items in Pivot Table
I want the pivot table to show the rank of the values rather than the values
themselves. Is this possible? I use Excel 2003. Thanks. Pivot Table of Values: Employee Sales Visits LR % Mike 100,000 12 86.4% Joe 750,000 19 78.1% Sue 65,000 14 69.3% Ann 1,200,000 17 61.4% Jessica 900,000 24 58.0% Bob 375,000 6 98.0% Want to see pivot table of ranks (sales and visits descending; LR ascending): Employee Sales Visits LR % Mike 5 5 5 Joe 3 2 4 Sue 6 4 3 Ann 1 3 2 Jessica 2 1 1 Bob 4 6 6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank items in Pivot Table
Seems easiest if, to the right of the pivot, you were to enter
=RANK(B2,B$2:B$7) and paste down and across. Then, just hide columns B - D. "Noel" wrote: I want the pivot table to show the rank of the values rather than the values themselves. Is this possible? I use Excel 2003. Thanks. Pivot Table of Values: Employee Sales Visits LR % Mike 100,000 12 86.4% Joe 750,000 19 78.1% Sue 65,000 14 69.3% Ann 1,200,000 17 61.4% Jessica 900,000 24 58.0% Bob 375,000 6 98.0% Want to see pivot table of ranks (sales and visits descending; LR ascending): Employee Sales Visits LR % Mike 5 5 5 Joe 3 2 4 Sue 6 4 3 Ann 1 3 2 Jessica 2 1 1 Bob 4 6 6 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank items in Pivot Table
Sean,
Unfortunately, I need something more dynamic. The people using this pivot table will page by geographic territory -- with each territory having a different number of employees. "Sean Timmons" wrote: Seems easiest if, to the right of the pivot, you were to enter =RANK(B2,B$2:B$7) and paste down and across. Then, just hide columns B - D. "Noel" wrote: I want the pivot table to show the rank of the values rather than the values themselves. Is this possible? I use Excel 2003. Thanks. Pivot Table of Values: Employee Sales Visits LR % Mike 100,000 12 86.4% Joe 750,000 19 78.1% Sue 65,000 14 69.3% Ann 1,200,000 17 61.4% Jessica 900,000 24 58.0% Bob 375,000 6 98.0% Want to see pivot table of ranks (sales and visits descending; LR ascending): Employee Sales Visits LR % Mike 5 5 5 Joe 3 2 4 Sue 6 4 3 Ann 1 3 2 Jessica 2 1 1 Bob 4 6 6 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank items in Pivot Table
Dynamic Table that reconfigures
with territory and number of employees, but only in Excel 2007: http://www.mediafire.com/file/oejtzw...01_02_09a.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I do a RANK calculation in a Pivot Table | Excel Discussion (Misc queries) | |||
Rank a quantity column using a pivot table | Excel Discussion (Misc queries) | |||
Rank in Pivot Table | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
pivot table - Rank | Excel Discussion (Misc queries) |