Pivottable AutoShow top 10 - show as percentage of whole source group?

**kuraitori** · 02-09-2010, 05:13 PM

Hello,

Have a pivot table of customers and sales volume. Want table to highlight our top 10 customers (hence the top ten autoshow) but want to express their volume as percentage of whole customer base (10% of our sales is due to our top customer).

Currently, I've been using Count expressed as % of total. Unfortunately that expresses it based on only our top ten customers, instead of the entire customer base

any ideas?

**ronanm** · 02-15-2011, 06:14 AM

Hi kuraitori

Same issue here. Did you ever come across a method of showing the % of the "total" not just the "total" of the Top 10?

Ronan

**Blake 7** · 02-15-2011, 06:23 AM

EDIT: Hi Ron....

You need to start your own thread and not attach questions to old threads. Part of the forum rules.

Hope this helps.

If you PM a mod i'm sure one will delete this post

**Blake 7** · 02-15-2011, 06:35 AM

--------------------------------------------------------------------------------

EDIT: Hi Ron....

You need to start your own thread and not attach questions to old threads. Part of the forum rules.

Hope this helps.

If you PM a mod i'm sure one will delete this post