Expanding Fields in Excel 2007 Pivot Table

MMIIKKEE

New Member
Joined
Sep 16, 2006
Messages
13
Hello... anyone feeling on the ball on Monday morning?

I have a pivot table (Excel 2007) with 3 groups before a count field:

Country / Drink / Size / Count of names

The issue is when I expand an item in the second group (say Lager) for a country (say UK) that item expands in all country fields not just for the UK... I can't see a setting to turn this off

Not sure if Mr.Excel accepts links but here's a pic to paint 999 words...

http://www.mikefardell.com/uploads/2/2/3/1/2231052/1125808.jpg

Many thanks... Mike

PS sorry in advance about the "UK = country" thing...
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,220,965
Messages
6,157,120
Members
451,399
Latest member
alchavar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top