+ Reply to Thread
Results 1 to 3 of 3

Filter away the smallest values in a Pivot Table

  1. #1
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Filter away the smallest values in a Pivot Table

    Hello

    I want to filter out any data value in a pivot table that is smaller than a certain number. Basically I am trying to make a report and the really small activities are not interesting, it just blurs the pivot table and makes it big. There is some explanation in the sheet as well.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,985

    Re: Filter away the smallest values in a Pivot Table

    Select A6. Click the Row Labels filter and apply a value filter for Sum of Hours greater than 5.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Filter away the smallest values in a Pivot Table

    Ka-ching!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I filter Pivot Table Values?
    By flyboy54 in forum Excel Charting & Pivots
    Replies: 21
    Last Post: 05-24-2013, 10:17 AM
  2. Show/Filter top values in a pivot table
    By spangpang in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-14-2013, 07:39 AM
  3. Pivot Table Filter, retain all values
    By Reitz in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-18-2013, 05:09 PM
  4. Excel 2007 : How to Filter TOP 5 Values in PIVOT Table
    By yourskarthik in forum Excel General
    Replies: 3
    Last Post: 12-30-2009, 11:26 AM
  5. filter pivot table with multiple values?
    By hamsup1o in forum Excel General
    Replies: 0
    Last Post: 09-29-2009, 04:08 PM

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