+ Reply to Thread
Results 1 to 6 of 6

Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

  1. 03-14-2017, 10:40 AM #1
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

    Hello,

    I have two slicers "Month" and "Year", I need a VBA code to auto-filter the PT on selection in Slicer for example, user select Month - march and Year 2017, Filter should be applied Month - April to March and Year - 2016 & 2017.


    Thanks!
    Reply With QuoteRegister To Reply
  2. 03-14-2017, 03:53 PM #2
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

    Any input please?
    Reply With QuoteRegister To Reply
  3. 03-15-2017, 07:57 AM #3
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

    Hello Tried doing this but ended up getting type mismacth error. Hope someone can help me now

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-15-2017, 11:20 AM #4
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

    I used this code

    Please Login or Register  to view this content.
    Worked well till here. Would anyone know where am i going wrong.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-15-2017, 01:22 PM #5
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

    Not having done much with pivotitems, I have little insight into the problem, but see if THIS helps at all?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  6. 03-15-2017, 03:14 PM #6
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Autofilter last 13 months in PIVOT TABLE upon Slicer Selection

    Thanks Arkadi but was not something i was looking for.
    I have to use two conditions to get the filter for last 13 month, year and Month. For some reason i am getting this error. Can anyone guide me here


    Please Login or Register  to view this content.
    Last edited by Biplab1985; 03-15-2017 at 11:54 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Referencing pivot tables against cell value itself in a pivot table operated by slicer.
    By hbuzz in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-04-2016, 02:58 PM
  2. [SOLVED] Pivot chart won't change when I add months using the slicer
    By Mrs.H in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-02-2015, 04:59 PM
  3. Change Pivot Table Column field on Slicer selection (Excel 2013)
    By kevboyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2014, 11:36 PM
  4. Limiting a pivot table slicer to one selection
    By behrensf84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 09:25 PM
  5. [SOLVED] Use slicer selections on one pivot table to filter another pivot table
    By porkandbeans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2013, 12:30 AM
  6. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 AM
  7. PIVOT table autofilter based on data validation cell selection
    By fredstyler in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-16-2011, 09:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1