Home // Blog & Excel Tips // Creating multiple pivot tables but grouping the data in different ways

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Creating multiple pivot tables but grouping the data in different ways

Comments Closed
Uncategorised

Pivot Tables for Excel 2007A common pivot table problem is that when you create multiple pivot tables, you sometimes group the data on pivot table, and when you go to another pivot table (which you don’t want the grouping to apply to), the grouping is forced on the pivot table.

The solution to avoid this is:

First create a pivot as normal.

When creating your other pivots, you MUSTN’T copy the pivot, nor must you go to the source document and create a new pivot.

For the second pivot you need to press the Alt key then press D then press P key to get the Pivot table wizard activated.  You can click through to the end. When Excel recommends that you link to the other pivots data, you click NO.   This will cause two unique pivots so that grouping applied to one will not affect the other one.

 

Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page