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!

[TABLE="width: 972"]
<tbody>[TR]
[TD][/TD]
[TD]P1 - Critical[/TD]
[TD][/TD]
[TD]P2 - High[/TD]
[TD][/TD]
[TD]P3 - Medium[/TD]
[TD][/TD]
[TD]P4 - Low[/TD]
[TD][/TD]
[TD]Total Incidents[/TD]
[TD]Total Met SLA[/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]App 1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]App 2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]App 3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]App 4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]App 5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]App 6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]P1 - Critical[/TD]
[TD][/TD]
[TD]P2 - High[/TD]
[TD][/TD]
[TD]P3 - Medium[/TD]
[TD][/TD]
[TD]P4 - Low[/TD]
[TD][/TD]
[TD]Total Incidents[/TD]
[TD]Total Met SLA[/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD]Incidents[/TD]
[TD]Met SLA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]App 1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]91%[/TD]
[/TR]
[TR]
[TD]App 2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]79%[/TD]
[/TR]
[TR]
[TD]App 3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]App 4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]App 5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]92%[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]95%[/TD]
[/TR]
[TR]
[TD]App 6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]91%[/TD]
[/TR]
</tbody>[/TABLE]

 

[cyrilbrd]

Hi,
Would that be acceptable?
[TABLE="class: grid, width: 1008"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Data[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]P1 - Critical[/TD]
[TD][/TD]
[TD]P2 - High[/TD]
[TD][/TD]
[TD]P3 - Medium[/TD]
[TD][/TD]
[TD]P4 - Low[/TD]
[TD][/TD]
[TD]Total # of Incidents[/TD]
[TD]Total Met_SLA[/TD]
[/TR]
[TR]
[TD]App[/TD]
[TD]# of Incidents[/TD]
[TD] Met_SLA[/TD]
[TD]# of Incidents[/TD]
[TD] Met_SLA[/TD]
[TD]# of Incidents[/TD]
[TD] Met_SLA[/TD]
[TD]# of Incidents[/TD]
[TD] Met_SLA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]App 1[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]1[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]10[/TD]
[TD]100.00%[/TD]
[TD]11[/TD]
[TD]90.91%[/TD]
[/TR]
[TR]
[TD]App 2[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]12[/TD]
[TD]83.33%[/TD]
[TD]2[/TD]
[TD]50.00%[/TD]
[TD]14[/TD]
[TD]78.57%[/TD]
[/TR]
[TR]
[TD]App 3[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]1[/TD]
[TD]100.00%[/TD]
[TD]1[/TD]
[TD]100.00%[/TD]
[/TR]
[TR]
[TD]App 4[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]4[/TD]
[TD]100.00%[/TD]
[TD]3[/TD]
[TD]100.00%[/TD]
[TD]7[/TD]
[TD]100.00%[/TD]
[/TR]
[TR]
[TD]App 5[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]8[/TD]
[TD]100.00%[/TD]
[TD]13[/TD]
[TD]92.31%[/TD]
[TD]21[/TD]
[TD]95.24%[/TD]
[/TR]
[TR]
[TD]App 6[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]2[/TD]
[TD]0.00%[/TD]
[TD]3[/TD]
[TD]100.00%[/TD]
[TD]18[/TD]
[TD]100.00%[/TD]
[TD]23[/TD]
[TD]91.30%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[TD]3[/TD]
[TD]0.00%[/TD]
[TD]27[/TD]
[TD]92.59%[/TD]
[TD]47[/TD]
[TD]95.74%[/TD]
[TD]77[/TD]
[TD]90.91%[/TD]
[/TR]
</tbody>[/TABLE]



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?