Hey guys, new member here. Im sorry if this has been asked before, but I cannot seem to find it in search.

Is there a macro to Reset the pivot table? as in get rid of every field in the table? like 'ClearAllPivotTableDataDammit!'

Why I need this is because I need to make some command buttons for my boss who is not too pivot table savy.
So I want to put buttons like "per month" "per customer" "per item" on top of the table, so that when he clicks on it, the table rearranges itself.

I have tried several macros myself. But the usual problem is, the button works if pressed from the default pivot state, but then after the pivot changes, or if something is removed the macro would err.
So the only way I can think of doing this effectively is to wipe the table clean then rearrange the fields.
I dont know, is there a better way of doing it?

Thanks in advance.