N
navin
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
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