pivottable field

I have two PivotTable fields in the row section, seen below, I need the Trading Partner field to repeat next to the Transaction Set field on the entire pivot table. Below is also an example of what I am looking for. Is there a way to do this automatically so I do not have to do this by hand...

Hello everyone, This is my first topic :) I will explain in details : I have 4 pivot tables from different sources. I have another table with a list that I need to filter at the pivot table. In the end I expect to create a macro that reads this list, apply the filter and print the result for...

I have created VBA code to create a pivot table. When I run through it with the Play button in VBA Editor, it works perfectly. When I created a button to run the macro it is stopping with Run-time Error '91': Object Variable or With Block variable not set. When I run the Debug it goes to the...

I'm working on a very long Macro for my job and I am just about finished, but this is the last part and no matter what I do, I can't seem to figure out the fix. In this PivotTable, I need to have "Managers" as the columns and everything else (i.e. all of the months) in the Values section, with...

Hi, I am trying to run a macro to expand/collapse pivot fields whenever the pivot table is updated. Pivot table is filtered using a slicer that is connected to one of the pivot table row fields (not a pagefield). The first time I make a selection in the slicer and pivot table is filtered...

Hi I have a Pivot table with two row variable; SKU (priamry) and Customer Name (secondary). What I need is for the SKU name to appear for every customer (I have some other formulas that are drawing from SKU name). I hope this makes sense. I have tried to add it into columns but names dont...

Hi, I searched on all forum and I don't find the solution. I have error 1004, Unable to get the... on ligne: With PT.PivotFields("Product"). Then I tried a recorded macro... But it doesn't work too... I don't know why. Please answer if you have any suggestion. This is my code: Best, themeltdown...

Hi All, I am trying to design a pivot table and subsequent "getpivotdata" within a workbook that I need assistance with. First I have a table of customer data and in Cell $B$58 in sheet "Account Growth" I have a listbox with choices: "Existing", "Prospect" and "COI", I have a pivot table in...

In my pivot table, I want non-productive hours and total hours side by side in the same row. The problem is that non-productive hours are showing as count of non-productive and not as sum of non-productive, unless I put them in DATA field with total hours that creates two lines item. When I put...