How to Stop Pivot Table Grouping Affecting Another Pivot Table

Question

HiI'm trying (on a Mac) to create 2 pivot tables with the same data set but separate groupings and cannot seem to find the answer. &nbsp;It seems possible on a PC with Alt D P.&nbsp;Any help will be fantastic.&nbsp;J.&nbsp;

riny_van_eekelen · Answer

jc_007&nbsp;Make sure that you have not accidentally disabled automatic grouping of dates in tables and filters (Excel, Preferences, Tables&amp;Filters). Not disabling this will create date hierarchies (date, month, quarter, year) as separate fields to chose from, when you drag dates into the row or column field. Now you can create one PT e.g. on a monthly basis and another, off the same data source, on an annual basis.

jc_007 · Answer

Riny_van_Eekelen&nbsp;&nbsp;Thank you, this was the problem, now ok.&nbsp;Regards.&nbsp;j.&nbsp;&nbsp;

Forum Discussion

How to Stop Pivot Table Grouping Affecting Another Pivot Table

Share

Resources