Doubt on Pivot Table Group Selection

[rskfriends]

Hi All,

Please clarify my pivot group doubt.

when i group a pivot table date field it change in multiple pivot table.

i want change where i selected pivot table only, don't change the other pivot data's. How to do it.

pivot_Group.xlsx

[XOR LX]

Hi,

You need to create a separate cache for each Pivot Table.

Several options to do this, one of which is to create the second using the PivotTable Wizard (ALT+D+P) and selecting "No" in the third window when asked whether you would like the new report to be based on the same data as your existing report.

Regards

[rskfriends]

Hi XOR LX

Thanks for your valuable time spend for my clarification.

I tried your ans. its works.

[XOR LX]

You're welcome.