akswartz85
New Member
- Joined
- Mar 31, 2010
- Messages
- 49
How do I calculate row percentage by subgroup within a pivot table?
<style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="58"><col width="152"><col width="112"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
Right now, it is calculating the percentage by the total row, but I want it totaled by the subgroup (i.e. by the total diplomal_ontime= 0 and then diploma_ontime = 1).
Is that possible?
<style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>
COUNT of diploma_ontime | diploma_ontime | s_male | ||||||||
0 | 0 Total | Total | 1 | 1 Total | Grand Total | |||||
hs_name1 | 0 | 1 | 0 | 1 | 0 | 1 | ||||
Hope High School | 0.7% | 1.1% | 1.8% | 51.8% | 46.4% | 98.2% | 100.0% | |||
James High School | 0.7% | 1.7% | 2.3% | 0.0% | 0.0% | 52.1% | 45.6% | 97.7% | 100.0% | |
Juniper High School | 0.6% | 2.2% | 2.8% | 0.0% | 0.0% | 52.8% | 44.4% | 97.2% | 100.0% | |
Kennedy High School | 1.3% | 3.1% | 4.3% | 0.0% | 0.0% | 55.6% | 40.0% | 95.7% | 100.0% | |
King High School | 0.9% | 2.4% | 3.4% | 50.7% | 46.0% | 96.6% | 100.0% | |||
Lincoln High School | 0.6% | 0.5% | 1.1% | 55.3% | 43.6% | 98.9% | 100.0% | |||
Meadowbrook High School | 1.4% | 1.6% | 3.0% | 50.2% | 46.8% | 97.0% | 100.0% | |||
North Falls High School | 0.5% | 1.1% | 1.6% | 50.6% | 47.7% | 98.4% | 100.0% | |||
Orange High School | 0.5% | 1.4% | 1.9% | 50.9% | 47.3% | 98.1% | 100.0% | |||
Polk High School | 0.9% | 1.2% | 2.2% | 0.0% | 0.0% | 52.2% | 45.6% | 97.8% | 100.0% | |
South Falls High School | 0.2% | 1.4% | 1.6% | 0.0% | 0.0% | 51.3% | 47.2% | 98.4% | 100.0% | |
Upper Hills High School | 1.7% | 2.2% | 3.9% | 56.8% | 39.4% | 96.1% | 100.0% | |||
Washington High School | 0.9% | 1.0% | 1.9% | 0.0% | 0.0% | 53.7% | 44.3% | 98.1% | 100.0% | |
Grand Total | 0.8% | 1.5% | 2.3% | 0.0% | 0.0% | 0.0% | 52.4% | 45.4% | 97.7% | 100.0% |
<colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="58"><col width="152"><col width="112"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
Right now, it is calculating the percentage by the total row, but I want it totaled by the subgroup (i.e. by the total diplomal_ontime= 0 and then diploma_ontime = 1).
Is that possible?