You could loop through a field - if this field-selection could change your pivot properly maybe through conditions on fields and expressions it should be possible.
If you used macros you could select or change the properties how do you want.
But often is it the easiest and fastest way to use many specialized objects maybe hidden in a special print-sheet.
