SOLVED

pivot table behavior related information required

Occasional Contributor

I have one excel workbook .

one table as source data and created many pivot tables with this same source data. in the same work book.

when i change the date format in group , it changes in all pivot tables . 

In some pivot tables i want to show it as year, and in some other as month, 

how to stop changing all the pivot tables. only one should change where i made change.

best regards

1 Reply
best response confirmed by ndmalam (Occasional Contributor)
Solution

@ndmalam 

Please check How do I “separate” Pivot Tables or other similar blogs on how to separate PivotTable caches. In general it's better to work using data model.