+ Reply to Thread
Results 1 to 4 of 4

How make a pivot table display values greater than "X"

  1. #1
    Registered User
    Join Date
    01-27-2010
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    10

    Post How make a pivot table display values greater than "X"

    I need some help.

    Below is a Text Version of a Pivot Table:

    Month Month Month
    Product Type 10 11 12 Grand Total

    Widget A 3 5 10 18
    Widget B 2 3 5 10
    Widget C 2 2 2 6
    Widget D 1 1 1 3

    In reference to Grand Total column - How do I create a filter within pivot table that only shows values > 5?

    If the filter was to work, in my example Widget D would not be present.

    Can someone help me?

  2. #2
    Registered User
    Join Date
    01-27-2010
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: How make a pivot table display values greater than "X"

    Filter.png

    Adding a screen shot of the example pivot table... Text version did not display correctly. Thank in advance for any help you can provide.

  3. #3
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: How make a pivot table display values greater than "X"

    Hi Austin,

    Can you attach an example spreadsheet??
    Thanks,

    Bonny Tycoon


  4. #4
    Registered User
    Join Date
    01-27-2010
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: How make a pivot table display values greater than "X"

    Example.xlsx

    I have attached an example worksheet with pivot table. I look forward to your feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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