Expanding Fields in Excel 2007 Pivot Table

M

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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

ajjava
  • Question Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
2K
ajjava
ajjava
J
  • Question Question
PivotTable Fields - Field list is auto expanding every time I pull a new field into the pivot table...how to I change this.
Replies
1
Views
856
jms493
J
T
  • Question Question
Apply different date filters to specific column values in a pivot table
Replies
1
Views
1K
Fluff
Fluff
C
  • Question Question
vba code to auto expand and collapse fields in a pivot table
Replies
0
Views
5K
cpv
C
T
  • Solved
OLAP Pivot Table Expand/Collapse Buttons in Column Fields not Working
Replies
1
Views
1K
tjess
T

Forum statistics

Threads
1,223,246
Messages
6,170,987
Members
452,373
Latest member
TimReeks

Share this page

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