Sorting Options for Pvt Tables

  • Thread starter Thread starter lj
  • Start date Start date
L

lj

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
 
Back
Top