hi,

i want one of the pivot field in data as sum, but that columnheader will be changing every time the users runs the macro.

is there any solution for this.


Thanks!