Pivot Table - Calculated Field to show percentage of adjacent values

[jxsavage]

Greetings,

I'm working on a table in which I need to calculate the percentage of one summed field compared to it's adjacent field. For example, if I have two columns and the first row shows values 3 for column A and 1 for Column B, then column B should really show 33.33% Below is a more detailed example of my table showing what I can produce and what I really need.

Thanks in advance!

	P1 - Critical		P2 - High		P3 - Medium		P4 - Low		Total Incidents	Total Met SLA
Row Labels	Incidents	Met SLA	Incidents	Met SLA	Incidents	Met SLA	Incidents	Met SLA
App 1	0	0	1	0	0	0	10	10	11	10
App 2	0	0	0	0	12	10	2	1	14	11
App 3	0	0	0	0	0	0	1	1	1	1
App 4	0	0	0	0	4	4	3	3	7	7
App 5	0	0	0	0	8	8	13	12	21	20
App 6	0	0	2	0	3	3	18	18	23	21
	P1 - Critical		P2 - High		P3 - Medium		P4 - Low		Total Incidents	Total Met SLA
Row Labels	Incidents	Met SLA	Incidents	Met SLA	Incidents	Met SLA	Incidents	Met SLA
App 1	0	0%	1	0%	0	0%	10	100%	11	91%
App 2	0	0%	0	0%	12	83%	2	50%	14	79%
App 3	0	0%	0	0%	0	0%	1	100%	1	100%
App 4	0	0%	0	0%	4	100%	3	100%	7	100%
App 5	0	0%	0	0%	8	100%	13	92%	21	95%
App 6	0	0%	2	0%	3	100%	18	100%	23	91%

<tbody>
</tbody>

 

[cyrilbrd]

Hi,
Would that be acceptable?

	Data
	P1 - Critical		P2 - High		P3 - Medium		P4 - Low		Total # of Incidents	Total Met_SLA
App	# of Incidents	Met_SLA	# of Incidents	Met_SLA	# of Incidents	Met_SLA	# of Incidents	Met_SLA
App 1	0	0.00%	1	0.00%	0	0.00%	10	100.00%	11	90.91%
App 2	0	0.00%	0	0.00%	12	83.33%	2	50.00%	14	78.57%
App 3	0	0.00%	0	0.00%	0	0.00%	1	100.00%	1	100.00%
App 4	0	0.00%	0	0.00%	4	100.00%	3	100.00%	7	100.00%
App 5	0	0.00%	0	0.00%	8	100.00%	13	92.31%	21	95.24%
App 6	0	0.00%	2	0.00%	3	100.00%	18	100.00%	23	91.30%
Grand Total	0	0.00%	3	0.00%	27	92.59%	47	95.74%	77	90.91%

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

calculated field "Met_SLA" is ='Met SLA' /Incidents
Option pivot 'error values as' let blank, or you could set a (0) zero to reflect 0% as shown above...


Would that work for you?