Create new pivot table, using a variable

[Richard U]

I am maintaining code from a coworker who had har coded the creation of a pivot table as part of a report.

The needs ard expanding, and the pivot table needs more flexibility.

I haven't done this before and need some hdlp with the syntax