ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Top 20 excluding specific items (https://www.excelbanter.com/excel-discussion-misc-queries/166186-pivot-table-top-20-excluding-specific-items.html)

Sarah (OGI)

Pivot Table Top 20 excluding specific items
 
I have a pivot table and I'd like to a) group the top 20 companies by the
amount of business they've transacted but excluding "Unspecified" and
"(blank)", and b) group the remaining companies as "Other" and include
"Unspecified" and "(blank)" in this selection.

Any ideas how I can do two separate groupings where there are some companies
that I don't want to include in the top 20?


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com