pivot chart, how to show all others

[MartinL]

Hi

I have a pivot table/chart that I need to show the sums as top 20 (or any other number) and All others
How can I do this.

I have an example file here:
https://app.box.com/s/mb6xl82bjn6t6ahqrzax

 

[Andrew Poulsom]

I don't understand what you want to do, but that pivot table is linked to an external source.

 

[MartinL]

Hi Andrew

What I want to do so show the Top 10 products in a chart along with their share of the real total not just the filtered total

Thanks for pointing out the external source issue, I have re-uploaded the sheet using the source data on the same sheet

 

[MartinL]

It looks like I may have a answer to my dilema
It involves two pivots and a helper column

Convert to a table as its easier to work with
use an awkward but small formula to decide what to show as all others
turn off auto sort and do it manualy or all others may appear in the middle rather than at the end.
Ok ots clumsy and there are wizards out there that can do better, but this is my attempt and it's available for downloading to laugh at or improve.

 

[Andrew Poulsom]

To do that you would have to add a column to your source data that calculates the percentage with a formula like:

=C2/SUM(C$2:C$58826)

and add that column to your pivot table.