Results 1 to 12 of 12

PivotTable - Grey Multiple Filter Per Field

Threaded View

  1. #1
    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.


        Dim p_i As PivotItem
        
    
        Dim objTable As PivotTable, objField As PivotField
        
        ActiveWorkbook.Sheets("DataBase").Select
        Range("A1").Select
        
        Set objTable = Sheet1.PivotTableWizard
        ActiveSheet.Name = "Booking Desk"
    
        Set objField = objTable.PivotFields("CS_RESPONSIBLE")
        objField.Orientation = xlRowField
        Set objField = objTable.PivotFields("CLOSED_BY_CMA")
        objField.Orientation = xlRowField
        Set objField = objTable.PivotFields("RESPONSIBILITY_NAME")
        objField.Orientation = xlColumnField
        Set objField = objTable.PivotFields("COMMENT_DESCRIPTION")
        objField.Orientation = xlPageField
        objField.Position = 1
    
        Set objField = objTable.PivotFields("RESPONSIBILITY_NAME")
        objField.Orientation = xlDataField
        objField.Function = xlCount
        
        ActiveSheet.PivotTables(1).Name = "BookingDesk"
        
        ActiveSheet.PivotTables("BookingDesk").ManualUpdate = True
              
            With ActiveSheet.PivotTables("BookingDesk").PivotFields("COMMENT_DESCRIPTION")
        For Each p_i In .PivotItems
            p_i.Visible = True
        Next
        For Each p_i In .PivotItems
            If Not InStr(1, p_i.Value, "BK -", vbTextCompare) > 0 Then
               p_i.Visible = False
            End If
        Next
        End With
          
        With ActiveSheet.PivotTables("BookingDesk").PivotFields("RESPONSIBILITY_NAME")
            .PivotItems("Booking Desk").Visible = True
            For Each p_i In .PivotItems
                If p_i.Name <> ("Booking Desk") Then
                    p_i.Visible = False
                End If
            Next
        End With
        
        With ActiveSheet.PivotTables("BookingDesk").PivotFields("CS_RESPONSIBLE")
            On Error Resume Next
            .PivotItems("Adriana Ortigueira").Visible = True
            .PivotItems("Caio Carvalho").Visible = True
            .PivotItems("Daniel Alves").Visible = True
            .PivotItems("Fábio Ignácio").Visible = True
            .PivotItems("Ikaro Vieira").Visible = True
            .PivotItems("Juliana Tenório").Visible = True
            .PivotItems("Kleber Cardozo").Visible = True
            .PivotItems("Lucas Silva").Visible = True
            .PivotItems("Marcelle Bueno").Visible = True
            .PivotItems("Nara Santos").Visible = True
            .PivotItems("Pedro Cardoso").Visible = True
            .PivotItems("Robson Santos").Visible = True
            .PivotItems("Thiago Fernandes").Visible = True
            .PivotItems("Cintia Migues").Visible = False
            .PivotItems("Ronaldo Magueta").Visible = False
            .PivotItems("Talita Santos").Visible = False
            .PivotItems("André de Jesus").Visible = False
            On Error GoTo 0
        End With
        
        ActiveSheet.PivotTables("BookingDesk").ManualUpdate = False
    
        ActiveSheet.PivotTables("BookingDesk").ColumnGrand = False
        ActiveSheet.PivotTables("BookingDesk").TableStyle2 = "PivotStyleDark16"
    
        With ActiveSheet.PivotTables("BookingDesk")
            .ColumnGrand = True
            .RowGrand = False
        End With
           
    End Sub

    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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1