I have tried to create a macro to add a measure to all the pivot tables in my workbook but cannot get the
syntax correct.
We are running on Microsoft Office Home and Business 2016+
I have managed to add a measure to all the pivot Charts. See macro code attached:rofl:
Sub ChangePivot()
'...