pivotitem

Hi mrExcel! I'm currently working on a report whereby I'm trying to create multiple macros in one worksheet with some slicers inserted. I have one slicer working with the below macro. It consists of the period names, i.e. Jan, Feb,Mar, Q1, Q2, FY. So if I click on "Feb" it'll only show me all...

Hi, In a pivot table created through vba there is Pivotfield with dates (DD.MM.YYYY). I grouped them with months and years and showed all items. Worksheets("Pivot_Tabellen").PivotTables(TableName).PivotFields("UTC Date").DataRange.Cells(1).Group Start:=True, End:=True, _...

Hi, How do I write a code for pivot filter to unselect all and only select "AB1" and "CD*". I tried to edit from the code that I recorded but it failed and I'm not sure if i'm suppose to use "If Not". Is there any other better way? I'm still a beginner in vba, hope you guys can help me :help...

Hello, I'd like to set Pivotitems in Date Pivotfield to visible but I have error 13 type incompatibility. I set the Date field format to DateFormat and I could get the pivotitem name. Here is the code: Sub filterdates() Dim pitem As PivotItem...

Goodday all, I am trying to move a PivotItem to the last position in my Pivot table and found on the web below VBA code, but it doesn't work :mad:. Does anybody have an idea why? Dim total As Integer total = ActiveSheet.PivotTables("PivotTable1").PivotFields("Vehicle Type...

Hi, I am struggling with a macro to set multiple pivot items based on multiple cells. I have tried different codes but they don't work as they should be. In this case, I would like the macro to set the months based on cells "'Validatie'!AQ2" and "'Validatie'!AQ3". These cells contain numeric...

I'd like to use VBA to change all of the pivot table report filters for several pivot tables on one sheet to the same single filter criteria (Excel 2007). I have several pivot tables on one sheet. Each one reports on data from a different sheet in the same workbook. Each pivot table uses the...

Hello everyone, it's my first post here. This is Excel 2007. I'm operating on a quite big database in Excel, 250 k rows. From these data, with VBA I create a pivot table. Then I am trying to show only several items from one column, for example the column is "Country". Then I have a lot of...

Hello All, Objective: Seeking solution to extract Pivot table index Item value that matches display order. Description:Simple For Each loop that indexes through the Pivot Table return pivotItems based on ascending order. What I need is a way for vba to return pvtItem content based on the...

Hi All, I have one table which has a Name list and another pivot table which has a column 'Attribute_Name'. I want to filter the 'Attribute_Alias' to show only the Names in the table. Even after setting Autosort to Manual and making the Manual update as True, I am still getting the below...

Hi, I have a pivot table with two columns: Code and Quantity. I want to loop through the Quantity column and hide all values = 0. I can do this easily by incorporating this into my code: pt.PivotFields("Code").PivotFilters.Add _ Type:=xlValueDoesNotEqual...

I found some VBA code to separate a detailed list based on a pivot table filter. I modified the code from creating a separate file for each pivot item to creating a separate tab. That part works great. The detailed list is tasks by employee and the separated filter is director. The detailed...