pivotitems

With ActiveSheet.PivotTables("PivotTable1").PivotFields("Assignment Descriptor" _) .PivotItems("CCR Review").Visible = False .PivotItems("CCR Review ").Visible = False End With There are numerous other fields listed, about 25 in total Question 1: Is there a way to just provide a wild card so...

Is there a way to hide a list of PivotItems in a single command? Using Excel2010, standard pivot (not OLAP data source) I'm looking for a way to significantly speed up the code execution. NB I already suspended the recalculation, the video refresh, set .ManualUpdate = True, ... So I'm...

Hey Guys, I have series of sub functions running through, while running I need a User form to pop up asking user to select pivot filters. I've broken it down to steps while running sub. Step 1 (Macro Running): I will be creating a pivot table (say PT1) with all pivot items selected initially...

Hello, I'm currently struggling to get a piece of VBA working the way I expect. I am attempting to iterate through a PivotTable that is filtered under a PageFilter, pull each individual item in the table and put them in a range of cells. The PivotTable looks as like this: My current code is...

Hello, I'm trying to cycle trough values in very simple Pivot Table. Two rows and one Sum value. Now I see the very strange shift during the cycle - please see the screenshot. Yellow outlined cells are shifted - with the incorrect "Month". Red outlined cells are the duplicates - they are the...

Greetings, I am having trouble on what should be an easy code. Sub Loop() Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Set pt = Sheet9.PivotTables("AC") Set pf = pt.PageFields("Name") For Each pi In pf.PivotItems pf.CurrentPage = pi.Value Next pi End Sub I get a...

Say that I have a pivot table and I want my filter to just show the items I want. I cannot stick to a certain value such as item1 and item7 to be false because it may be present or not present but the items2,3,4,5,7 are the data I want to be always present. Is there and if else statement I...

Hi Everyone, Im trying to find easy solution on how to select all Pivot items. Things is that my data base is updated with new entries very often so i need to refresh pivot and then open filters and click on "select all" each time, and then un-check "blanks" What i have now is : Sub...

I have a pivot table that shows usernames and a count of how many times each username appears in my data. The pivot table also has a filter field which filters the data by course title. I have set the filter so that the pivot table only displays data for 1 specific course. This gives a list of...

I'm trying to get all possible combinations of some pivottables with page fields (pivottable filters). I know you can't set all items in a page field to false, and I tried to handle that, but my logic is screwed somehow because I'm getting duplicates not all values. This seems like it should be...

I have several pivot tables that only contain text comments by product and location. The problem I have is that when I refresh the pivot table the pivot items filter gets set to (blank) only which results in nothing being shown in the table. I tried writing code that would (select all) and...

I've tons of examples on here of how to reference a PivotValue and even find the Row source, but not quite what I'm looking for. I have a pivot table that is made from a summary of 3 different tables so the drill down doesn't work on it. I want to use the BeforeDoubleClick and just write it...

Good afternoon, I'm trying to use a variable to select filter in a pivot. The code i'm working with is: "" Workbooks("Banana - Copy.xlsx").Sheets("PIVOT").PivotTables("PivotTable1").PivotFields("Week").CurrentPage = "(All)" With Workbooks("Banana -...

Objective: to use a list of items in a specified range to update a pivot chart I know the code below points to what I am needing, but I think I need to create a variable to step through a range so that I can add them to the code below: (something like Range = Sheets("Main").Range("A1:A10") for...

Hi, I was wondering how can I group pivot items based on the name ?, e.g. I want to group all the pivot items that are not named US or CA or BR , I did a little research on the forum and I found a code that I can adapt but is not very elegant , so I'm wondering if you guys have a better...

I have this large macro that when it is contained as one large macro the code runs perfectly without issue. Sub RSLDashboardtesting() Dim APPSPD As Worksheet With Application .ScreenUpdating = False .Calculation = xlCalculationManual .DisplayAlerts = False...

Hi, I have a pivottable where I want to "filter" some data depending on if they are in other table or not, the data I want to filter are alphanumeric names. My idea is to save the data (names) in an array and then compare the pivotitems to the array items and set visible the matches but it...

Hello, (first post) I haven't found an answer to my exact problem and haven't managed to solve it myself. Below is the example data: <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=256 x:str><COLGROUP><COL style="WIDTH: 48pt" span=3...

What I'm trying to do is to get excel to show selected or all pivotitems that I have loaded into an array - without looping through each array value, as this requires huge amounts of calculation. A way of thinking about what I want to do is the "with" statement ie With...

I am trying to work through the VBA syntax to check the Visible property of a group of PivotItems in a Page Field of a Pivot Table. With the VBA code below I can accurately test the Visible property of a ROW field but testing the Visible property of the PAGE field returns FALSE in every...