| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank a quantity column using a pivot table
Hello
I have a pivot table that lists columns 'account customer', 'qty on order', '% of total on order'. I would like to add a RANK column in between the 'qty on order' & '% of total on order' so it ranks the customers in order of highest number of orders to lowest. How can I modify the pivot table to include a rank column?? -- TIA Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table - Same column Name | Excel Discussion (Misc queries) | |||
| Can I add a quantity to every cell in a column using a formula? | Excel Discussion (Misc queries) | |||
| Rank in Pivot Table | Excel Worksheet Functions | |||
| Add a column outside pivot table and... | Excel Discussion (Misc queries) | |||
| pivot table - Rank | Excel Discussion (Misc queries) | |||
Linear Mode
