+ Reply to Thread
Results 1 to 13 of 13

Combining report filters on Pivot Charts

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Combining report filters on Pivot Charts

    Hi All,

    I have about 10 pivot tables and charts. Each table is refined by "week number". Is it possible to combine all the report filters so that the tables will be updated from the one drop down menu?

    Thanks,
    Adam

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    Hi,

    Check out this link -

    http://www.needforexcel.com/#!Update...f28ffc7eecbe3f

    You will need something like this

    Please Login or Register  to view this content.
    Just change the Caption "Date" to whatever is on your pivot table..

    Also change this part to wherever your Drop Down is

    Please Login or Register  to view this content.
    Last edited by NeedForExcel; 08-31-2015 at 06:00 AM.
    Cheers!
    Deep Dave

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    You can wrap the above code in a Worksheet Change event, so that as soon as you select values from the Drop Down, all Pivots update on their own..

    Something like -

    Please Login or Register  to view this content.
    See the file attached.
    Attached Files Attached Files
    Last edited by NeedForExcel; 08-31-2015 at 06:51 AM.

  4. #4
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Combining report filters on Pivot Charts

    Sorry guys,

    Is this a macro? I have never used one before. I also have all pivot tables on the one sheet.

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    First of all, press F12 and save your workbook with .xlsm extension.

    Then on the Developer Tab, click on Visual Basic.. If Developer Tab is not enabled, here is how to do it
    http://www.needforexcel.com/#!Enable...7-85EDEE74C7C5

    Click On Insert > Module & Paste Code From Post #2 there

    Then Right Click on the sheet where the Drop Down List is there, and select View Code, Paste Code From Post #3 there.

    You will have to change minor things like .PivotFields("Date") & SheetName to what ever you are using..

    Refer this if required

    http://www.needforexcel.com/#!Update...f28ffc7eecbe3f

  6. #6
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Combining report filters on Pivot Charts

    Hi,

    Sorry to bother you but i cant get it working. I keep getting the following error.
    Last edited by Adamlee; 08-31-2015 at 06:51 AM.

  7. #7
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    Hi,

    See the file attached.

    Do not forget to enable Macros
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Combining report filters on Pivot Charts

    31.8.15.xlsx

    Readded link

  9. #9
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    Did the file attached in Post #7 not work for you?

  10. #10
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Combining report filters on Pivot Charts

    Apologies, i hadnt updated the page.

    I have enabled the macro i think, but the following error is coming up

    .PivotFields("Week Number").CurrentPage = Sheets("Sheet1").Range("A2").Text

  11. #11
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    I think you have not tried the file attached in Post #7

    I have done everything there and it is working fine..

  12. #12
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Combining report filters on Pivot Charts

    AHHH Apologies,

    I had the weeks as 1531 instead of 31.

    Its working perfectly now.

    Thank you soo much

  13. #13
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Combining report filters on Pivot Charts

    No Problem..

    Cheers!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Change Report Filters for two pivot tables on the Same Sheet
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2015, 04:28 PM
  2. Filter report filters based upon previous report filters!!??
    By jackie_m in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2015, 05:17 AM
  3. Pivot Table with 2 Report Filters.
    By DSL1970 in forum Excel General
    Replies: 1
    Last Post: 04-16-2013, 07:17 PM
  4. Combining Multiple Pivot Table Report Filters
    By csivell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 02:21 PM
  5. Multiple Report Filters in Pivot Table
    By ramjet in forum Excel General
    Replies: 0
    Last Post: 07-12-2012, 01:45 PM
  6. Multiple Pivot Charts w/ different filters
    By jablo1312 in forum Excel General
    Replies: 0
    Last Post: 06-21-2012, 01:28 PM
  7. Excel pivot table row labels and report filters
    By exodus125 in forum Excel General
    Replies: 4
    Last Post: 10-29-2008, 09:41 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