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