+ Reply to Thread
Results 1 to 3 of 3

Adding Filter Buttons to a Pivot Table

  1. #1
    Registered User
    Join Date
    02-27-2006
    Posts
    19

    Adding Filter Buttons to a Pivot Table

    I would like to add filter buttons at the top of my pivot table so that I can filter/sort the data fields. A pivot table offers selection buttons on the row and column fields, but not on the data fields. I added the filter buttons and tried the "sort ascending" option and it sorted all of my data fields alphabetically instead of the numbers in ascending numeric order. Is there any way to turn off the sort feature of the filter buttons or get them to actually sort the numbers vertically instead of sorting my data field headings horizontally?

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    850
    You can have the data fields also as "page" fields (In both)

    Page fields allow for selection.

    You can also sort by the field you choose (From the column or row firlds) in the field configuration.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    02-27-2006
    Posts
    19
    The page field idea is interesting, but it is primative compared to the custom filter functionality through a filter button. The user can only select one option through a page field whereas the user can filter using an inequality expression (greater than/less than) with a cusom filter.

    I think the solution is to not use a pivot table format for detailed views of data where exception analysis is important to the use of the data and a non-pivot table with filter buttons offers a better format for the analysis.

+ 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