View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
margie margie is offline
external usenet poster
 
Posts: 26
Default 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%