+ Reply to Thread
Results 1 to 12 of 12

PivotTable - Grey Multiple Filter Per Field

  1. 06-19-2017, 03:26 PM #1
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Unhappy PivotTable - Grey Multiple Filter Per Field

    Dears,
    I need your help (once again...) regarding my pivot Table.

    Once the pivotTable is created, I cannot make filter on the date by "Date Filter".
    Only the "value Filter" is available.

    I tried several option but without success until now.
    May I kindly ask you to help me on this matter.


    Please Login or Register  to view this content.

    Once I can able the multiple Filter, I need to create a "Date Filter" - "Last Week"

    You can see screenshot enclosed.

    Hope you will be able to help me
    Regards


    Date Filter.png
    Last edited by ozstrik3r69; 06-19-2017 at 03:29 PM.
    Reply With QuoteRegister To Reply
  2. 06-19-2017, 03:41 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: PivotTable - Grey Multiple Filter Per Field

    Your date values also include time values. That's why you don't have the Date Filter available.

    Before you create the pivot table, you would have to strip the time values from the dates in your data. You could use a formula like this in an empty column
    =INT(A2)
    ...where A2 is a Date-Time value.

    Then use the column with the Date-only formulas in your Pivot Table.

    The macro could create the date-only formula column before creating the pivot Table.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 06-19-2017, 03:51 PM #3
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    AlphaFrog

    Thank you for your answer but even this solution not working.
    See screenshot attached.

    Date Filter2.png


    I am trying different things found on internet but nothing worked till now.
    Reply With QuoteRegister To Reply
  4. 06-19-2017, 04:04 PM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: PivotTable - Grey Multiple Filter Per Field

    Do you have one so-called date in the data that is not a recognized date? Maybe it's text or a formula error?
    Reply With QuoteRegister To Reply
  5. 06-19-2017, 04:10 PM #5
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    Quote Originally Posted by AlphaFrog View Post
    Do you have one so-called date in the data that is not a recognized date? Maybe it's text or a formula error?
    I was looking for that also but nothing is incorrect.

    I tried to change also :
    * Extension (XLSM, XLSB,....)
    * I tried to insert in my VBA a multiplefilters but nothing (maybe I did not insert it well...)


    * I tried to use the same database to do another PivotTable (manually) and itīs work.
    Reason why I said that it is coming from my VBA...It is like something changed during the process.

    I Keep looking for a solution on internet

    Waiting for your feedback
    Regards
    Reply With QuoteRegister To Reply
  6. 06-19-2017, 04:20 PM #6
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    See enclose Excel File
    I could be easier to help me maybe...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 06-19-2017, 04:24 PM #7
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    Dears,
    Sorry the first file was protected on the VBA Propertie.
    See enclosed the file without password

    Regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 06-19-2017, 04:29 PM #8
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: PivotTable - Grey Multiple Filter Per Field

    Quote Originally Posted by ozstrik3r69 View Post
    See enclose Excel File
    I could be easier to help me maybe...
    I have an older version of Excel, so I cannot use your Pivot Table.

    Also, your code module is still password protected in the second workbook attachment.

    I don't have any other ideas. Sorry.
    Reply With QuoteRegister To Reply
  9. 06-19-2017, 04:32 PM #9
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    Thank You AlphaFrog.

    Will wait if someone else can help me.

    My very best regards
    Reply With QuoteRegister To Reply
  10. 06-20-2017, 08:06 AM #10
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    Dears good morning

    May I ask i someone else can help me on this matter.
    I tried several things but nothing worked till now.

    Waiting for feedback
    Regards
    Reply With QuoteRegister To Reply
  11. 06-20-2017, 09:13 AM #11
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    Dears

    Still looking for a solution, I was wondering if the fact that I used the pivottablewizard turn mt PT unable to use multiple Filters.
    I try to find something on Internet but nothing for the moment.

    If you have any ideas.
    Regards
    Reply With QuoteRegister To Reply
  12. 06-20-2017, 03:03 PM #12
    ozstrik3r69
    ozstrik3r69 is offline
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotTable - Grey Multiple Filter Per Field

    Dears,
    An update regarding the situation below.

    I am still looking for a solution( it will help another person maybe) but what I did for the moment has been easier.
    I used the " record macro" and changed what was important for me.

    Regards
    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. Problem: Grey field appears on top of the window and below form when enabling Formula bar
    By Oleg_K in forum Excel General
    Replies: 20
    Last Post: 07-28-2020, 04:47 AM
  2. Pivottable Calculated Field based on multiple values
    By warrior2411 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-10-2016, 12:27 PM
  3. Can't drag PivotTable Field into Filter
    By Oksana in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-16-2016, 05:30 PM
  4. [SOLVED] Setting .CurrentPage of PivotTable to Filter or Multiple Items
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2014, 06:59 PM
  5. VBA - 1 pivot filter control multiple pivots with multiple field options
    By bwolsky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2014, 06:19 PM
  6. 2007 PivotTable and filter on multiple values
    By xxxyyyy in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-22-2011, 11:38 PM
  7. Multiple Layers of Filter in a PivotTable
    By jdmilly in forum Excel General
    Replies: 0
    Last Post: 01-30-2009, 06:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1