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