i want to change the data field in the pivot table using
i tried to record the macro also , it also does't work
i don't want to use wizard.
macro record the following lines
.Orientation = xlDataField
.Position = 1
to record the macro, i remove the AmtUS field and put the
if i run this macro then both fields are there.
Please guide me to remove AmtDkk field from the data
portion using VBA.
i want to use only one field at a time .
Plesae help me in the same
Thanx in advance