+ Reply to Thread
Results 1 to 2 of 2

Pvt Table Question

  1. #1

    Pvt Table Question

    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.


  2. #2
    Ed Ferrero
    Guest

    Re: Pvt Table Question

    Hi,

    To show the top 10 values for a field - double-click the field heading,
    click 'Advanced' check the top 10 AutoShow button.

    Ed Ferrero
    http://edferrero.m6.net


    >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.
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1