Pivot table, display a value underneath another value in the values zone.
 

Hi,
this is driving me nuts.
Excel 2007.
I'm trying to get a value to display underneath another value in the values
zone of my PT.

I have (let's say ) Sales by Region and by Year and Qtr.

Year 2009
Qtr 1 Qtr2
Region A 1000 1000
Region B 1000 1000

I want to get the percent of sales added in.
So I add in the Sales a second time as a % and Excel by default diplsay it
lke this

Year 2009
Qtr 1 Qtr2
Region A 1000 50% 1000 50%
Region B 1000 50% 1000 50%


But I want this
Year 2009
Qtr 1 Qtr2
Region A 1000 1000
50% 50%
Region B 1000 1000
50% 50%

And I can't find it in the menu.
This used to be the default display in XL2003 (if I remmeber correctly.)
Now it's gone and the trick to get it back is buried real deep.
I did figure it out about a month ago, but I can't remember how.

AHA, TIA
Rosalie