Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank in Pivot Table
I created a pivot table that shows sales by customer by month. I grouped the
months into quarters. Now, I would like to rank the customers by sales for each quarter - give each customer a rank for Q1, Q2, Q3, Q4 sales. Is ranking possible in a pivot table? And, is it possible to have a rank for each quarter? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank in Pivot Table
KrispyData wrote:
I created a pivot table that shows sales by customer by month. I grouped the months into quarters. Now, I would like to rank the customers by sales for each quarter - give each customer a rank for Q1, Q2, Q3, Q4 sales. Is ranking possible in a pivot table? And, is it possible to have a rank for each quarter? Not sure about ranking per-se, but did you know you can tell the PT to sort categories based on values? Double click a category control (e.g., Quarter) | Advanced | Autosort Options | Descending | Using field "sum of sales" or something similar for a top-down sort. Depending on your PT layout you can have such sorts within sorts. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank in Pivot Table
Excel 2007 Pivot Table
Same procedure as smartin's, plus a few tricks. http://www.mediafire.com/file/o0mwvn...06_10_09c.xlsx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank in Pivot Table
Very neat, Herbert!
I like the trick of Sales^0 - definitely one to remember. -- Regards Roger Govier "Herbert Seidenberg" wrote in message ... Excel 2007 Pivot Table Same procedure as smartin's, plus a few tricks. http://www.mediafire.com/file/o0mwvn...06_10_09c.xlsx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank in Pivot Table
This partially worked for me, is there any way to control dublicate values,
as we are displaying "Running Total" so every next value is given a No. which is 1+pervious value, even if the Rank value is equal to previous value: Value Rank 10 1 9 2 9 3 7 4 both 9 shold be 2, any solution? "Roger Govier" wrote: Very neat, Herbert! I like the trick of Sales^0 - definitely one to remember. -- Regards Roger Govier "Herbert Seidenberg" wrote in message ... Excel 2007 Pivot Table Same procedure as smartin's, plus a few tricks. http://www.mediafire.com/file/o0mwvn...06_10_09c.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank Error in Pivot Table | Excel Discussion (Misc queries) | |||
Rank items in Pivot Table | Excel Discussion (Misc queries) | |||
Can I do a RANK calculation in a Pivot Table | Excel Discussion (Misc queries) | |||
Rank in Pivot Table | Excel Worksheet Functions | |||
pivot table - Rank | Excel Discussion (Misc queries) |