Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I break "% in row" at each subtotal?
If I break a pivot table by one column category, and then a second category,
can I calculate "% in row" by the second category, and not across the whole pivot table? Example: I want the % in the rows of Section 1 and Section 2 calculated independently, not as a total. In other words, the rows in each section should be calculated off 100%, not off the subtotal of each section. Confusing, I know. :) 1 Total 2 Total Team CMI DVCI CMI DVCI Unix 34.4% 20.8% 55.2% 21.9% 22.9% 44.8% Network 31.4% 29.9% 61.3% 20.4% 18.2% 38.7% Storage 44.9% 17.3% 62.2% 27.2% 10.6% 37.8% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |