Get the name of current pivot field
Hi,
Is it possible to get the name of the pivot field into a variable. i
am creating a pivot table through VBA code, i let users select the
fields which needs to be put into the DATA for Sum.
Ex.
In DATA, i have "Sum of ABC", so when i want to see "Sum of 123", then
i need to remove "Sum of ABC" from DATA field.
Please let me know how this can be achieved.
Thank you for the help.
Navin
|