getting the percentage of two rows in pivot table

[corporate_slave]

Hi All,

I'm new to excel and I'm trying to get the percentage of two data in a pivot table but it shows #DIV/0!. Anyone can help me? thank you.

[TABLE="width: 580"]
<tbody>[TR]
[TD]Owning Workgroup[/TD]
[TD](Multiple Items)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Service[/TD]
[TD](Multiple Items)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]Closed[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Source of Interaction[/TD]
[TD](Multiple Items)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year[/TD]
[TD]2015[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Count of M S First Contact Res[/TD]
[TD]Count of Interaction ID[/TD]
[TD]Average of FCR[/TD]
[/TR]
[TR]
[TD]Dec29-Jan04[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jan05-Jan11[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jan12-Jan18[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jan19-Jan25[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jan26-Feb01[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]14[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Feb02-Feb08[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]18[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Feb09-Feb15[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]15[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Feb16-Feb22[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Feb23-Mar01[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Mar02-Mar08[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]58[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Mar09-Mar15[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Mar16-Mar22[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]126[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Mar23-Mar29[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]122[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Mar30-Apr05[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]107[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Apr06-Apr12[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]120[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Apr13-Apr19[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]108[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Apr20-Apr26[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]91[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Apr27-May03[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]70[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]May04-May10[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]77[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]May11-May17[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]66[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]May18-May24[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]63[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]May25-May31[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]44[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jun01-Jun07[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]39[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jun08-Jun14[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]32[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jun15-Jun21[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]33[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Jun22-Jun28[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]1266[/TD]
[TD="align: right"]1307[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

clearly 4 divide by 4 is 1 and not error
so the second 4 is a zero

what is your formula in the calculated field ?

 

[corporate_slave]

clearly 4 divide by 4 is 1 and not error
so the second 4 is a zero

what is your formula in the calculated field ?

here's my formula ='M S First Contact Res'/'Interaction ID'

I'm trying to explore this kind of method aside from using =g9/h9 formula.

 

[oldbrewer]

try 'M S First Contact Res'*1/'Interaction ID'*1

 

[corporate_slave]

try 'M S First Contact Res'*1/'Interaction ID'*1

still no luck. =/

 

[corporate_slave]

try 'M S First Contact Res'*1/'Interaction ID'*1

still receiving the error. I wonder how I can get the result of 'M S First Contact Res'/'Interaction ID' in pivot

 

[oldbrewer]

copy the interaction id, open a new spreadsheet, paste it into A1, widen the column a bit, is the number on right or left of cell A1

 

[corporate_slave]

copy the interaction id, open a new spreadsheet, paste it into A1, widen the column a bit, is the number on right or left of cell A1

Thank you for your help, I finally have a glimpse on how calculated field works. I copied the data from the pivot and paste it to other sheet and I used pivot table on it. calculated field is working now.