M
Margie
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%
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%