Spreadsheet: 86943d1286895092-percentage-in-a-pivot-table-example
Sheet: Sheet4

 | Values |  |  |  |  | I would like it to look like this:
Row Labels | Sum of 301 | Sum of 302 | Sum of 303 | Sum of 304
1078 | 1 | 3 | 2 | 2 |  | 1078 |  |  |  |  | 8 |  | 1078 | 1 | 3 | 2 | 2
Q1 | 0 | 0 | 0 | 1 |  | Q1 |  |  |  |  |  |  | Q1 | 0 | 0 | 0 | 1
S3 | 0 | 1 | 1 | 1 |  | S3 |  |  |  |  |  |  | S3 | 0 | 1 | 1 | 1
[NAME] | 0 | 2 | 1 | 0 |  | [NAME] |  |  |  |  |  |  | [NAME] | 0 | 2 | 1 | 0
S7 | 1 | 0 | 0 | 0 |  | S7 |  |  |  |  |  |  | S7 | 1 | 0 | 0 | 0
1821 | 0 | 0 | 0 | 7
Q1 | 0 | 0 | 0 | 1
Q2 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 6
1863 | 1 | 2 | 1 | 8
Q1 | 1 | 1 | 1 | 6
[NAME] | 0 | 1 | 0 | 2
2900 | 1 | 0 | 0 | 1
Q1 | 1 | 0 | 0 | 0
Q2 | 0 | 0 | 0 | 1
S3 | 0 | 0 | 0 | 0
TZ | 0 | 0 | 0 | 0
2956 | 1 | 5 | 3 | 6
Q1 | 1 | 1 | 1 | 2
S3 | 0 | 4 | 2 | 4
2971 | 2 | 2 | 1 | 4
Q1 | 0 | 0 | 1 | 1
S3 | 2 | 2 | 0 | 3
3712 | 0 | 4 | 2 | 4
Q1 | 0 | 2 | 0 | 1
S3 | 0 | 2 | 2 | 3
4011 | 2 | 1 | 3 | 6
Q1 | 0 | 1 | 1 | 1
QZ | 2 | 0 | 2 | 4
S3 | 0 | 0 | 0 | 1
4315 | 2 | 2 | 1 | 3
Q1 | 2 | 1 | 1 | 1
TZ | 0 | 1 | 0 | 2
4375 | 0 | 2 | 0 | 2
TZ | 0 | 2 | 0 | 2
4685 | 1 | 1 | 0 | 4
[NAME] | 0 | 0 | 0 | 2
S7 | 1 | 1 | 0 | 2
5500 | 1 | 9 | 4 | 27
Q2 | 0 | 0 | 1 | 0
QZ | 0 | 4 | 1 | 11
S3 | 1 | 5 | 2 | 16
5586 | 2 | 0 | 0 | 1
Q1 | 2 | 0 | 0 | 1
Q2 | 0 | 0 | 0 | 0
S3 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0
5639 | 1 | 3 | 0 | 8
Q1 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 0 | 6
S7 | 0 | 2 | 0 | 2
5678 | 0 | 4 | 1 | 6
TZ | 0 | 4 | 1 | 6
5940 | 0 | 0 | 0 | 1
Q1 | 0 | 0 | 0 | 1
6200 | 1 | 2 | 2 | 2
Q1 | 0 | 0 | 0 | 0
Q2 | 0 | 2 | 2 | 0
S3 | 1 | 0 | 0 | 2
6524 | 0 | 5 | 1 | 7
Q1 | 0 | 2 | 0 | 1
S3 | 0 | 1 | 1 | 5
TZ | 0 | 2 | 0 | 1
6687 | 0 | 0 | 0 | 1
Q1 | 0 | 0 | 0 | 1
S3 | 0 | 0 | 0 | 0
6835 | 1 | 1 | 0 | 3
Q1 | 1 | 0 | 0 | 3
TZ | 0 | 1 | 0 | 0
6895 | 0 | 5 | 1 | 6
Q1 | 0 | 1 | 1 | 0
S3 | 0 | 4 | 0 | 6
6926 | 0 | 4 | 0 | 6
Q2 | 0 | 0 | 0 | 2
S7 | 0 | 4 | 0 | 4
7137 | 0 | 5 | 0 | 7
Q1 | 0 | 2 | 0 | 3
QZ | 0 | 1 | 0 | 1
[NAME] | 0 | 1 | 0 | 1
TZ | 0 | 1 | 0 | 2
7138 | 0 | 5 | 0 | 6
Q1 | 0 | 5 | 0 | 6
7391 | 1 | 2 | 2 | 4
Q1 | 1 | 0 | 0 | 3
QZ | 0 | 1 | 1 | 1
S3 | 0 | 1 | 1 | 0
7596 | 0 | 3 | 2 | 4
TZ | 0 | 3 | 2 | 4
7679 | 1 | 0 | 0 | 4
Q1 | 0 | 0 | 0 | 4
TZ | 1 | 0 | 0 | 0
7683 | 0 | 1 | 1 | 1
Q2 | 0 | 1 | 1 | 1
8424 | 1 | 2 | 1 | 3
Q1 | 0 | 1 | 1 | 0
QZ | 1 | 0 | 0 | 0
TZ | 0 | 1 | 0 | 3
8449 | 2 | 6 | 1 | 5
Q1 | 1 | 4 | 1 | 4
S3 | 0 | 1 | 0 | 0
[NAME] | 1 | 1 | 0 | 1
8704 | 4 | 2 | 0 | 5
[NAME] | 4 | 2 | 0 | 5
S7 | 0 | 0 | 0 | 0
8714 | 3 | 14 | 3 | 12
Q2 | 0 | 1 | 0 | 1
[NAME] | 0 | 4 | 0 | 2
S7 | 3 | 9 | 3 | 9
8940 | 0 | 0 | 0 | 1
TZ | 0 | 0 | 0 | 1
9116 | 3 | 1 | 3 | 0
S3 | 1 | 0 | 2 | 0
S7 | 2 | 1 | 1 | 0
9230 | 1 | 1 | 1 | 1
Q2 | 1 | 1 | 1 | 1
9236 | 0 | 2 | 1 | 1
[NAME] | 0 | 2 | 0 | 1
S7 | 0 | 0 | 1 | 0
9285 | 0 | 1 | 0 | 5
Q1 | 0 | 1 | 0 | 2
S3 | 0 | 0 | 0 | 3
[NAME] | 0 | 0 | 0 | 0
9568 | 0 | 4 | 0 | 7
Q1 | 0 | 4 | 0 | 3
QZ | 0 | 0 | 0 | 2
TZ | 0 | 0 | 0 | 2
9829 | 1 | 6 | 0 | 9
Q1 | 0 | 2 | 0 | 3
[NAME] | 0 | 1 | 0 | 1
TZ | 1 | 3 | 0 | 5
9852 | 2 | 2 | 1 | 3
Q1 | 2 | 2 | 1 | 2
[NAME] | 0 | 0 | 0 | 1
9856 | 3 | 3 | 0 | 3
Q1 | 1 | 0 | 0 | 0
[NAME] | 1 | 1 | 0 | 1
TZ | 1 | 2 | 0 | 2
9865 | 0 | 3 | 0 | 4
Q1 | 0 | 0 | 0 | 1
[NAME] | 0 | 0 | 0 | 1
S7 | 0 | 3 | 0 | 2
9889 | 0 | 1 | 1 | 8
Q1 | 0 | 1 | 1 | 8
(blank) | 0 | 0 | 0 | 0
(blank) | 0 | 0 | 0 | 0
Grand Total | 39 | 119 | 39 | 208