+ Reply to Thread
Results 1 to 7 of 7

Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

  1. #1
    Forum Contributor
    Join Date
    09-30-2008
    Location
    London
    Posts
    119

    Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

    Hi all,

    I am beginner of Excel Macro.
    I want something like Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank.

    I want...
    In Today Sheet I want Select Report Filter "Today" and refresh Pivot Automatically
    In Tomorrow Sheet I want select Report Filter "Tomorrow" and refresh Pivot if "Tomorrow" is not exists then select Blank

    Please see attached file for more explanation




    Thanks
    Vinay
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

    are you planning to physically have a column for Today and Tomorrow? or are you doing this as part of the visualisation of your problem?

    ie have a formula like
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in column D
    Last edited by humdingaling; 01-28-2016 at 07:15 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    09-30-2008
    Location
    London
    Posts
    119

    Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

    Hi,
    I want macro a select Report Filter Atutomatically.

    Let's assume in Data sheet Column D (Booking Day) we have "Tomorrow" in Some rows, then In Pivot table of Tomorrow Sheet report filter has to select "Tommorrow".

    If Data sheet Column D (Booking Day) we do NOT have"Tomorrow" , then In Pivot table of Tomorrow Sheet report filter has to select "Blank".

    Hope it's clear now!

    Thanks
    Vinay

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

    what version excel are you using

    i have a solution in mind that will not require you to have a column "D" for booking day (or not use it anyway) but it is dependant on your excel version

  5. #5
    Forum Contributor
    Join Date
    09-30-2008
    Location
    London
    Posts
    119

    Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

    Hi,
    I am Using Excel 2010.

    Hppay to see your solution if it's work!

    Thanks & Regards
    Vinay

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

    ok
    this solution works for excel 2007+

    i changed the datasource to be a named range which is the table i setup for your data

    below is the code i have used

    Please Login or Register  to view this content.
    the coding is commented so you can follow what is going on

    i couldn't think of a better way to check the pivot field filtering
    im sure there is a better way but this serves its purpose and the principal is adaptable to different solutions
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    09-30-2008
    Location
    London
    Posts
    119

    Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

    WOW! Excellent solution. It work like charm.

    Thanks a lot
    Vinay

+ 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 in Pivot Table's Report Filter
    By mxlew in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2015, 12:46 AM
  2. Replies: 8
    Last Post: 06-24-2014, 03:35 PM
  3. Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static
    By biasedobserver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2014, 03:38 PM
  4. Select (ALL) in a pivot table filter
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2013, 12:41 PM
  5. [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
  6. Place a number filter on a report filter in a pivot table
    By reuben.doetsch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2010, 12:41 PM
  7. Select and unselect items in a filter in pivot table
    By TPFKAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2010, 09:39 AM

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