Unwanted filter columns display in Pivot Table created by VBA

[apo]

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