+ Reply to Thread
Results 1 to 2 of 2

Greater than or equal to filter in Pivot table

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Berlin/Sweden
    MS-Off Ver
    Excel 2010
    Posts
    124

    Greater than or equal to filter in Pivot table

    I've made a rather large pivot table with maybe 10 values - now some of these values I need to filter. So I would like to use the filter greater than or equal but it doesn't appear anywhere.

    I remember doing this before in a pivot table... When I choose sort now I can only sort smallest to largest or vice versa and when I do More sort options it's not in there either.

    Edit:
    After closer inspection I realize I can't add data filters to the columns. It only says clear and when I try to clear data nothing happens.

    Edit #2:
    At another closer inspection I need to use Slicers - which was even more complicated. How do I filter a column on greater than or equal to X using slicers?

    Any ideas?

    Thanks.
    Last edited by Jonathan9; 09-24-2013 at 11:24 AM.

  2. #2
    Registered User
    Join Date
    09-24-2013
    Location
    Twin Cities, MN
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Greater than or equal to filter in Pivot table

    You should be able to filter the values by clicking on the drop down arrow on the value field in the Pivot Table Field List. Then click on "Value Filters". No need for slicers.

+ 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. Filter table Not equal to
    By jsuarez199 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2013, 09:27 AM
  2. Filter report in pivot table with "greater than" and "less than"
    By gygabyte017 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-29-2012, 08:08 AM
  3. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  4. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  5. [SOLVED] Why does -1, -1, and 2 equal 4 in a pivot table
    By DCarter56 in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-28-2005, 06:06 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