Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I determine and display my Time Zone? | Excel Discussion (Misc queries) | |||
Pivot table summary option--display list of values | Excel Worksheet Functions | |||
Lookup letters and display highest values in a pivot table | Excel Discussion (Misc queries) | |||
How do I display the time zone in Excel? | Excel Discussion (Misc queries) | |||
How to DISPLAY all data values in Pivot Table...not count, sum, etc | Excel Discussion (Misc queries) |