PivotTabel shows top 10 and others

A

Angus

Hi,

I want my pivotTable shows top 10 and remaining grouped as "Others"; for
example, I want to show top 10 customers and other customers grouped as
Others for each region (N. America, S. America, Europe, N. Asia, S. Asia,
Middel East, etc). As each region will have different top 10 and other
customers I cannot use Group function at Group and Show Detail.

This is a question bothering me for long time, thanks for helping.

Angus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top 5 grouping of material based on usage 2
Pivot Table: Top 10 1
Grouping Rows - Want Top Row to Show 2
Top 10 Report 2
Show Top 10 and sum the rest? 3
Top N list with "all others" 3
A Pivot Table challenge--I can't do it, can you? 5
Unable to get a query to count as zero if record is blank 5

Top