Forum

Notifications
Clear all

Pivot Chart Top 5 and "other"

4 Posts
2 Users
0 Reactions
1,026 Views
(@jaket)
Posts: 2
New Member
Topic starter
 

Hello, I currently have 25 locations with sales and would like to create a Pivot chart that shows the top 5 individually and have a 6th section labeled "all others".   I found that I can have a chart with top 5 only which does not help show market share or have all 25 which is too crowded for a pie chart.

The picture example is what I'm trying to create with a pivot chart. 

top-5-example.PNG

 

Thank you

 
Posted : 27/02/2021 9:55 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Jake

1) Sort your pivot table base on the %

2) Group the bottom 20 and rename it as "All others"

3) Collapse entire fields in the Pivot Table.

4) Create the Pivot Pie Chart

5) Add the data labels and format accordingly.

Please refer attachment.

Hope this helps.

Sunny

 
Posted : 28/02/2021 9:24 am
(@jaket)
Posts: 2
New Member
Topic starter
 

Thanks Sunny!   Appreciate the help

 
Posted : 28/05/2021 10:59 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Jake

Thanks for your feedback.

Glad to know that it helps.

Sunny.

 
Posted : 29/05/2021 3:48 am
Share: