+ Reply to Thread
Results 1 to 4 of 4

Set Pivot Table Value Filter with Cell

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    10

    Set Pivot Table Value Filter with Cell

    I am looking to use the number entered in a cell as the "greater than or equal to" value filter for my pivot table values "Order History" and "Percent Difference."

    I have two variables: Minimum Order History and Minimum Percent Difference (cells D3 & D4). I would like any entries that do not meet both pieces of criteria to disappear. I have zero VBA knowledge so hoping that someone will be able to assist me!

    The workbook is attached and any help is greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    105

    Re: Set Pivot Table Value Filter with Cell

    I'm not getting it a 100%.

    U don't want to see everything <100 and what with the 40%?

  3. #3
    Registered User
    Join Date
    01-11-2017
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    10

    Re: Set Pivot Table Value Filter with Cell

    Sorry for being unclear. I only want to see entries where Order History is greater than 100 AND the percent difference is greater than 40%. However, I need to be able to change these numbers as different groups have different parameters.

    Please let me know if you need any further clarification. Thanks!

  4. #4
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    105

    Re: Set Pivot Table Value Filter with Cell

    Hey Montefortej,

    I'm out off time but i haven't found it a 100%.

    The >100 is no problem, the more then 40% is a little struggle...
    I'm having an issue with 0.4 or 40 (as in 40%)...

    Maybe someone else can help from here?

    I hope i've helped a little bit
    Attached Files Attached Files

+ 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. Set pivot table value filter with cell value
    By montefortej in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-10-2017, 12:50 PM
  2. Pivot table filter based on a cell
    By agnieszka85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2016, 08:09 AM
  3. Pivot Table to filter according to cell value
    By torrmel9701 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-08-2014, 04:15 PM
  4. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  5. 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
  6. Pivot table filter from cell value
    By bravebart in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2012, 09:51 AM
  7. 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

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