Pivot Table

  • Thread starter Thread starter Bridget Stacy
  • Start date Start date
B

Bridget Stacy

I have a pivot table that summarizes sales data. Does the
Pivot Table give me the ability to show only those
advertisers with a total monthly billing value of $250K or
more?
 
What about adding a row in the original worksheet which
gives the value 1 if the billing value is of 250 or more
and 0 if not. Then redo a pivot table?
 
You can use a field Top Ten feature to limit what's shown.

Right-click on a field button, e.g. Company.
Select Field Settings, click Advanced.
For Top 10 AutoShow, select on, and type or select a number
Click OK, click OK
 
I didn't know that feature existed -- thank you!
-----Original Message-----
You can use a field Top Ten feature to limit what's shown.

Right-click on a field button, e.g. Company.
Select Field Settings, click Advanced.
For Top 10 AutoShow, select on, and type or select a number
Click OK, click OK




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Click to expand...
 
Back
Top