A
ArcticWolf
Hi,
I have a pivot table with 2 fields in 'row'. 1st is Job Role, 2nd is
Payscale (there are many payscales for each job role). 'Data' is suming the
total people for each payscale.
I want to get a % of each payscale as a total for the 1st field and not for
the whole column or the row.
Job Role,Payscale,# of people,% of Job role
Accountant,Band1,1,6.67%
Band2,2,13.33%
Band3,4,26.67%
Band4,1,6.67%
Band5,7,46.67
Account Total,,100, 100%
Advisor,Band1,10,33.33%
Band2,5,66.67%
Advisor Total,,15,100%
TIA,
AW
I have a pivot table with 2 fields in 'row'. 1st is Job Role, 2nd is
Payscale (there are many payscales for each job role). 'Data' is suming the
total people for each payscale.
I want to get a % of each payscale as a total for the 1st field and not for
the whole column or the row.
Job Role,Payscale,# of people,% of Job role
Accountant,Band1,1,6.67%
Band2,2,13.33%
Band3,4,26.67%
Band4,1,6.67%
Band5,7,46.67
Account Total,,100, 100%
Advisor,Band1,10,33.33%
Band2,5,66.67%
Advisor Total,,15,100%
TIA,
AW