Pivot Table & Grouping Top Items

X

xdc

New Member
Joined
Aug 19, 2004
Messages
3
Hi there !
I have not found the solution for this yet - so thanks for those who have an idea to answer :)

I have a pivot table which summarize suppliers & their amounts
This works great but I want to show only the top 10 suppliers AND :eek: keeping all the others in a group called "Others" for instance...
Another problem is quite similar but I want just to retain the suppliers which counted for 90% of the total amount & the remaining as "Others"

Is anybody having an clue on how to do that in the pivot table ? :wink:
Note : actually I work around this problem by using formulas in the worksheet against the main pivot table...
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
Upvote 0
Thanks Marc for your reply (y) - that's ± what I've done as work around.

To be more detailled, the problem is that the table supplier/amount is the result of the pivot and not the DB :oops: . In the database, I have a large number of single amounts reffereing to several purchase orders of several misc. items from all the suppliers. The total is then summarized by supplier in the Pivot table.
Therefore, I can't apply the formulas proposed directly in the DB... :cry:
And that why I was looking for a solution "inside" the pivot table :rolleyes:

Do you understand the issue ?
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Multiple pivot tables on the same sheet
Replies
2
Views
288
Woftae
W
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
840
adambc
A
J
  • Question
Pivot Table formula when items are in same column
Replies
3
Views
683
GlennUK
G
S
  • Question
VBA or Slicer / Power Query - Is it possible to select pivot table fields (column headers)
Replies
1
Views
634
Sheila8659
S

Forum statistics

Threads
1,214,920
Messages
6,122,279
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top