Hi..
I am generating a Pivot Table via VBA. I made it manually first and then tried to replicate it with code.The issue is that the Pivot table created by code displays 2 extra column filters (fields).
In the Pivot table that was manually made.. these 2 extra fields are where I want them (nested within the first columns field).
Strange thing is that when I look at the settings for the manually made Pivot table compared to the code created Pivot table.. they are identical.
Any advice will be greatly appreciated.
I have attached a sample workbook.. if you press the "Create Pivot Table" button on Data Sheet.. the generated Pivot table will be added to a new sheet.. you can then see what i mean by comparing that to the Pivot Table i manually made on the "Desired Pivot Table" sheet..
You will see in columns B and C.. a "Products" and "Count" filter... whereas they should be nested within Column A (Description)..
Note: Also posted here: http://www.ozgrid.com/forum/showthread.php?t=179228
Bookmarks