ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I break "% in row" at each subtotal? (https://www.excelbanter.com/excel-discussion-misc-queries/250502-can-i-break-%25-row-each-subtotal.html)

margie

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%



All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com