Sort top 50 in Pivot table

G

Guest

Hello I only want the pivot table to show me the top fifty products. this
is what I did - pivot - sort top 10 - descending - using field (Product
Description ) - ON - show - top 50 - using field - sum of total - OK
- table looks the same as before except that the font in the column entitled
Product description is now blue all products show in descending order not
just the first 50 thanks
 
G

Guest

Maybe you can assign a rank in your source table. I.e., "In top 50" and "Not
in top 50". Then, sort your pivot table to show only those items that are in
the top 50.

Dave
 
D

Debra Dalgleish

How is the pivot table set up? Is product description the only field in
the row area? If not, you may be seeing the top 50 per region, or
whatever other field you have in the row area.

If that's the problem, and you just want to see the top 50 products, you
could make another copy of the pivot table, and only show products in
the row area.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Controlling how many rows of data are displayed in t 1
Sort in a Pivot Table 1
Pivot Table Soret 1
Pivot Table - Compare Dates & calc. % 1
How do I sort pivot table data by subtotals? 2
Pivot Table Data Column Sort Excel 2007 1
Pivot table drill down data 2
Pivot Table Set Up 2

Top