Is it possible to show a value as a % of a different column in a pivot table? I have my table set up to show # of days missed by department and shift. My columns total days missed for people who have worked 30, 60 and 90 days and I also have a total column at the end. Sample from my table below:
Row Labels 0-30 31-60 61-90 Total
Dept 100 23 14 13 51
1st 10 5 4 19
2nd 8 3 5 18
3rd 5 6 2 13
I want to show the data as a % of the total -- so the first value would show as 45% (23/50). I haven't been able to get what I want so far. It seems like all the custom calculations are only available within its own column. Is it possible to do this within the actual pivot table?
Thanks,
Row Labels 0-30 31-60 61-90 Total
Dept 100 23 14 13 51
1st 10 5 4 19
2nd 8 3 5 18
3rd 5 6 2 13
I want to show the data as a % of the total -- so the first value would show as 45% (23/50). I haven't been able to get what I want so far. It seems like all the custom calculations are only available within its own column. Is it possible to do this within the actual pivot table?
Thanks,
Last edited: