Pivot Charts - Top Ten And Everything Else

M

Mike

I have a Pivot table that shows monthly sales by client. Approximately 200
clients are shown. As with most businesses, about 80% of the sales comes from
20% of the clients.

I want to create a pivot chart that will show the individual results for the
the top ten clients along with all other clients grouped together as a single
result. Can this be done?
 
Top