corporate_slave
New Member
- Joined
- Jun 22, 2015
- Messages
- 10
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]
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]
Last edited: