| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table top 60-80%
Hello,
I would much appreciate if someone could tell me how to extract the following from a pivot table: I have a table of total sales per person and per region, and would like to see only the top 60% or the top 80% of sales. Many thanks! Emma. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table top 60-80%
It depends on what you mean by 60%. For example:
John 220 Jim 80 Trevor 60 Nigel 40 David 30 Tony 22 George 20 William 15 Gregor 10 Randolph 3 If you mean the top 60% of salespeople, then its the first 6 entries (out of 10). If you mean 60% of sales, then its only the first two entries. -- Gary''s Student - gsnu200781 "3307" wrote: Hello, I would much appreciate if someone could tell me how to extract the following from a pivot table: I have a table of total sales per person and per region, and would like to see only the top 60% or the top 80% of sales. Many thanks! Emma. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table top 60-80%
Thanks for replying.
I mean the top 60% of sold item (data present in the underlying database: item1 : 20K item2: 30K item3: 5K, etc (+10,000 items)) the pivot should still show total per person and per region, and it should ideally be possible to show this on all items, top 80%, or top 60%. hope this clarifies. "Gary''s Student" wrote: It depends on what you mean by 60%. For example: John 220 Jim 80 Trevor 60 Nigel 40 David 30 Tony 22 George 20 William 15 Gregor 10 Randolph 3 If you mean the top 60% of salespeople, then its the first 6 entries (out of 10). If you mean 60% of sales, then its only the first two entries. -- Gary''s Student - gsnu200781 "3307" wrote: Hello, I would much appreciate if someone could tell me how to extract the following from a pivot table: I have a table of total sales per person and per region, and would like to see only the top 60% or the top 80% of sales. Many thanks! Emma. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
