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.

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.

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.