locked
I want to hide the filter from the pivot table RRS feed

  • Question

  • I am connecting sass  database using Excel, from the pivot table i can able to see the cube result.

    ex: we have many juris .in that always i want to see the particular juris data alone.

    we have filter option but if we use this, customer possible to change the filter so i want to hide the filter from pivot table,its possbile ?,please suggest me 

    Thanks 


    pandiyan


    Tuesday, April 5, 2016 2:33 PM

Answers

  • Hi Pandiyan,

    If got you right you need to have one of PivotFields filtered and at the same time to prevent users from filtering this PivotField.

    Answering a question in another thread here I made a sample:

    https://www.dropbox.com/s/nihktrnzbndop9r/PivotTableFilterChange_1.xlsm?dl=0

    To disable filtering "Pets" PivotField you can use something like the following:

    Sub DisableSelection()
    
        Dim pt As PivotTable
        Dim pf As PivotField
        
        Set pt = Sheet2.PivotTables("PetFilter")
        Set pf = pt.PivotFields("Pets")
        
        pf.EnableItemSelection = False
    
    End Sub

    Is that what you asked for?

    Sergiy Vakshul

    • Proposed as answer by Sergiy_Vakshul Tuesday, April 5, 2016 6:54 PM
    • Marked as answer by David_JunFeng Tuesday, April 12, 2016 9:24 AM
    Tuesday, April 5, 2016 6:54 PM

All replies