+ Reply to Thread
Results 1 to 1 of 1

Between/greater than/less than filter options on manual filter field for Pivot Table

  1. #1
    Forum Expert Whizbang's Avatar
    Join Date
    Greenville, NH
    MS-Off Ver

    Between/greater than/less than filter options on manual filter field for Pivot Table

    I am running a Pivot Table where I have a couple of fields in the Manual/Report Filter section. When I go to filter those fields, I get the option to manually select each item. Fine. But there are a lot of items and it would be so much easier to just do a Between filter, which is only available if the field is in the row or column sections. Likewise I am adding in a Spin Button to spin through the records, displaying a range of values for that field. I set up a For Next loop to manually select each item, but that seems inelegant to me and I hope a Between method would be quicker.

    Note that I cannot add the field into my row or column sections as that would mess up my chart. I just need to filter on that field, not display it.

    Any suggestions? My Google-foo is not pulling up anything specific to my needs.
    Last edited by Whizbang; 03-20-2015 at 04:49 PM.

+ 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. Pivot Table not showing the value filter options - only Top 10!
    By abhi.ko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2014, 07:31 PM
  2. Greater than or equal to filter in Pivot table
    By Jonathan9 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-24-2013, 12:27 PM
  3. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  4. Replies: 0
    Last Post: 10-27-2011, 11:29 AM
  5. Pivot Table Data Filter Options Disappear
    By Pepikins in forum Excel General
    Replies: 1
    Last Post: 06-16-2005, 08:05 AM


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