+ 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,844

    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 Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    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.
    Remember what the dormouse said
    Feed your head

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

    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