G
Guest
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
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