pivotitems

  1. Z

    [VBA] Excel PivotTable Filtering

    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...
  2. T

    How to hide many pivotitem at once

    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...
  3. P

    User Form to Select Pivot Table Filters

    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...
  4. A

    Filter through PivotItems under a PageFilter [VBA]

    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...
  5. D

    Cycle through Pivot Table values -

    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...
  6. P

    Error 5 VBA code PivotItem Loop

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

    VBA If else then statement for pivot items

    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...
  8. B

    How to select all pivot items with .PivotItems(?????).Visible = True

    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...
  9. C

    VBA Count Visible Pivot Items

    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...
  10. B

    Iteration through PivotTables/PageFields/Items not working

    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...
  11. C

    Select all PivotItems and uncheck (blank)

    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...
  12. K

    Capture PivotFields rows and column from PivotItem in VBA

    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...
  13. T

    using variable to select filter in pivot

    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 -...
  14. D

    Update Chart Filters Based on Range In Spreadsheet

    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...
  15. J

    Group pivot items

    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...
  16. R

    CRITICAL TIME FRAME - SUPER STUMPED!!!!! - Run-time error '1004': Unable to get the PivotItems property of the PivotField class

    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...
  17. Y

    Hiding pivotitems matching with external criteria

    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...
  18. T

    PivotTable - Hide item based on different item

    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...
  19. M

    VBA - show all pivotitems based on object array

    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...
  20. P

    Testing for PivotItems.Visible in a Pivot Table Page Field

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

Some videos you may like

This Week's Hot Topics

Top