Home

Pivot tables connected

%3CLINGO-SUB%20id%3D%22lingo-sub-664653%22%20slang%3D%22en-US%22%3EPivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664653%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EHello%2C%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EI%20created%20two%20pivot%20tables%20in%20different%20worksheets%20of%20a%20same%20workbook%2C%20but%20I%20am%20facing%20some%20problems%20when%20I%20try%20to%20group%20or%20ungroup%20only%20one%20of%20them.%20Because%20both%20tables%20have%20time%20as%20lines%2C%20whenever%20I%20try%20to%20group%20the%20days%20into%20months%20in%20one%20pivot%20table%2C%20the%20other%20one%20gets%20automatically%20grouped%2C%20which%20is%20a%20problem%20for%20the%20graphing%20results%20I%20am%20showing.%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EHow%20can%20I%20have%20the%20freedom%20of%20grouping%20and%20ungrouping%20one%20pivot%20table%20without%20altering%20the%20other%20one%3F%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivot%20tables%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664815%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325044%22%20target%3D%22_blank%22%3E%40GbiKripka28%3C%2FA%3E%26nbsp%3Byou%20might%20such%20issue%20if%20you%20have%20copy%20pasted%20a%20Pivot%20table.%20Try%20creating%20two%20separate%20Pivots%20from%20original%20data.%20I%20just%20tested%20with%20your%20scenario%20and%20it%20works%20perfectly%20for%20me.%20If%20you%20still%20face%20the%20issue%2C%20please%20share%20the%20file%20here.%3CBR%20%2F%3ENote%3A%20I%20am%20using%20office%202016%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664998%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F353690%22%20target%3D%22_blank%22%3E%40bhushanz%3C%2FA%3Ethank%20you%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunalely%20I%20created%20the%20two%20pivot%20tables%20separatedly%20and%20still%20it%20does%20not%20work.%20I%20will%20attach%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-665781%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-665781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325044%22%20target%3D%22_blank%22%3E%40GbiKripka28%3C%2FA%3E%26nbsp%3B%2C%20you%20created%20your%20Pivot%20Tables%20without%20adding%20data%20to%20data%20model.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20385px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117046iFBB697AA2DD98835%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20such%20case%20you%20need%20to%20separate%20Pivot%20Table%20caches.%20More%20details%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fpivot-cache-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fpivot-cache-excel%2F%3C%2FA%3E%20and%20in%20many%20other%20places.%20IMHO%2C%20with%20that%20better%20to%20create%20every%20new%20Pivot%20Table%20with%20old%20wizard%20Alt%2BD%2BP.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEven%20more%20better%20if%20you%20add%20data%20to%20data%20model%2C%20when%20caches%20will%20be%20separated%20automatically.%20Plus%20data%20model%20potentially%20gives%20you%20much%20possibilities%20to%20work%20with%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBoth%20variants%20are%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667611%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ethank%20you!%20Now%20it%20worked%20perfectly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-668720%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668720%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325044%22%20target%3D%22_blank%22%3E%40GbiKripka28%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
GbiKripka28
Occasional Contributor

Hello,

I created two pivot tables in different worksheets of a same workbook, but I am facing some problems when I try to group or ungroup only one of them. Because both tables have time as lines, whenever I try to group the days into months in one pivot table, the other one gets automatically grouped, which is a problem for the graphing results I am showing.

How can I have the freedom of grouping and ungrouping one pivot table without altering the other one?

 

Thank you

5 Replies

@GbiKripka28 you might such issue if you have copy pasted a Pivot table. Try creating two separate Pivots from original data. I just tested with your scenario and it works perfectly for me. If you still face the issue, please share the file here.
Note: I am using office 2016

@bhushanzthank you for your help

 

Unfortunalely I created the two pivot tables separatedly and still it does not work. I will attach the file.

 

Thank you

 

 

@GbiKripka28 , you created your Pivot Tables without adding data to data model.

image.png

In such case you need to separate Pivot Table caches. More details is here https://trumpexcel.com/pivot-cache-excel/ and in many other places. IMHO, with that better to create every new Pivot Table with old wizard Alt+D+P.

 

Even more better if you add data to data model, when caches will be separated automatically. Plus data model potentially gives you much possibilities to work with data.

 

Both variants are in the attached file.

@Sergei Baklanthank you! Now it worked perfectly

@GbiKripka28 , you are welcome