Pivot Table Macro not populate fields as recorded

[3345james]

Recorded a macro for a pivot table - when I ran it gave an error - at .Position = 2

The attached DOCX shows what the fields should be and what it shows

Any help to revise this is greatly appreciated.

Please Login or Register  to view this content.

[xlnitwit]

Hi,

You need to swap these two parts around

Please Login or Register  to view this content.

so that the data field is added first thus

Please Login or Register  to view this content.

If you don't do it in that order, adding the field again as a data field moves it from the row area to the data area because the field caption is the same. When you add it as a data field first, the caption is "Count of Same Address" and not "Same Address" so the move doesn't occur.

[3345james]

Perfect! Thanks
Jim