Sorting Options for Pvt Tables

I am creating several pvt tables that will be updated often with new
data. I want to know if there is any function within a pvt table that
I can use to set up my pvt table so that only the top 10 data points
are automatically displayed. So for example, if i have pvt table set
up to show brand name and then accounts for each brand name and I
sorted on accounts descending and only wanted the pvt table to show the

top 10 brands that had the highest total accounts. Is this possible?
Thanks.

Double-click on the Brands field button
In the Pivot Table Field dialog box, click the Advanced button
Under Top 10 AutoShow, select On
From the Show dropdowns, select Top, and 10
From the Using Field dropdown, select the field you want to measure
Click OK, click OK

[email protected] wrote:
> I am creating several pvt tables that will be updated often with new
> data. I want to know if there is any function within a pvt table that
> I can use to set up my pvt table so that only the top 10 data points
> are automatically displayed. So for example, if i have pvt table set
> up to show brand name and then accounts for each brand name and I
> sorted on accounts descending and only wanted the pvt table to show the
>
> top 10 brands that had the highest total accounts. Is this possible?
> Thanks.
>


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

This is exactly what I was looking for, thanks!!

You're welcome! Thanks for letting me know that it helped.

[email protected] wrote:
> This is exactly what I was looking for, thanks!!
>


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