VBA code to use same filed on Rows section of pivot table

[Ishwarind]

Hi ,
I need to use same field twice in rows section.
Please share vba code for the same.

[xlnitwit]

Hi,

You can't do that, either in code or manually. You would have to create a copy of the field in the source data. Why do you need to show the same information twice?

[Ishwarind]

Thanks xlnitwit.

Yes, right.
I need to group row feild tiems in several groups.

Say particular 5 items as one group, another 2 items as one group.
How can that be done using vba?

[xlnitwit]

You have to identify the relevant ranges in the row field area and then use the Group method. It's a bit ugly, but there is no other way I know of.