Hello Need a help in Pivot table.
Using the below raw data, i have created Pivot table which shows how many "calls", how many "Made" and "Miss". I also need SLA achived (Made/Miss), can I calculated this(SLA achived) in the pivot table it self.
Note: SLA Achived column given below is not part of pivot. What i really want is this possible to include this in the Pivot.
Regards,
NG
<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=4><COL><COL><COL><COL><COL></COLGROUP>
Using the below raw data, i have created Pivot table which shows how many "calls", how many "Made" and "Miss". I also need SLA achived (Made/Miss), can I calculated this(SLA achived) in the pivot table it self.
Note: SLA Achived column given below is not part of pivot. What i really want is this possible to include this in the Pivot.
Regards,
NG
Raw Data</SPAN> | Required data</SPAN> | |||||||||
Ticket</SPAN> | City</SPAN> | SLA</SPAN> | ||||||||
1654</SPAN> | CHESAPEAKE</SPAN> | Made</SPAN> | ||||||||
1655</SPAN> | COOKEVILLE</SPAN> | Miss</SPAN> | City | Made | Miss | Grand Total | SLA Achieved</SPAN> | |||
1656</SPAN> | IRVING</SPAN> | Made</SPAN> | CHESAPEAKE</SPAN> | 2</SPAN> | 1</SPAN> | 3</SPAN> | 67%</SPAN> | |||
1657</SPAN> | KALAMAZOO</SPAN> | Made</SPAN> | COOKEVILLE</SPAN> | 2</SPAN> | 1</SPAN> | 3</SPAN> | 67%</SPAN> | |||
1658</SPAN> | LAWRENCE</SPAN> | Made</SPAN> | IRVING</SPAN> | 3</SPAN> | 3</SPAN> | 100%</SPAN> | ||||
1659</SPAN> | LYNCHBURG</SPAN> | Made</SPAN> | KALAMAZOO</SPAN> | 3</SPAN> | 3</SPAN> | 100%</SPAN> | ||||
1660</SPAN> | MOOSIC</SPAN> | Made</SPAN> | LAWRENCE</SPAN> | 3</SPAN> | 3</SPAN> | 100%</SPAN> | ||||
1661</SPAN> | RALEIGH</SPAN> | Made</SPAN> | LYNCHBURG</SPAN> | 3</SPAN> | 3</SPAN> | 100%</SPAN> | ||||
1662</SPAN> | SPRINGVILLE</SPAN> | Made</SPAN> | MOOSIC</SPAN> | 2</SPAN> | 1</SPAN> | 3</SPAN> | 67%</SPAN> | |||
1663</SPAN> | SULPHUR SPRI</SPAN> | Miss</SPAN> | RALEIGH</SPAN> | 2</SPAN> | 1</SPAN> | 3</SPAN> | 67%</SPAN> | |||
1664</SPAN> | TANEYTOWN</SPAN> | Miss</SPAN> | SPRINGVILLE</SPAN> | 2</SPAN> | 1</SPAN> | 3</SPAN> | 67%</SPAN> | |||
1665</SPAN> | VERNON</SPAN> | Miss</SPAN> | SULPHUR SPRI</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 33%</SPAN> | |||
1666</SPAN> | CHESAPEAKE</SPAN> | Miss</SPAN> | TANEYTOWN</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 33%</SPAN> | |||
1667</SPAN> | COOKEVILLE</SPAN> | Made</SPAN> | VERNON</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 33%</SPAN> | |||
1668</SPAN> | IRVING</SPAN> | Made</SPAN> | Grand Total | 25 | 11 | 36 | 69%</SPAN> | |||
1669</SPAN> | KALAMAZOO</SPAN> | Made</SPAN> | ||||||||
1670</SPAN> | LAWRENCE</SPAN> | Made</SPAN> | ||||||||
1671</SPAN> | LYNCHBURG</SPAN> | Made</SPAN> | ||||||||
1672</SPAN> | MOOSIC</SPAN> | Made</SPAN> | ||||||||
1673</SPAN> | RALEIGH</SPAN> | Made</SPAN> | ||||||||
1674</SPAN> | SPRINGVILLE</SPAN> | Made</SPAN> | ||||||||
1675</SPAN> | SULPHUR SPRI</SPAN> | Miss</SPAN> | ||||||||
1676</SPAN> | TANEYTOWN</SPAN> | Miss</SPAN> | ||||||||
1677</SPAN> | VERNON</SPAN> | Miss</SPAN> | ||||||||
1678</SPAN> | CHESAPEAKE</SPAN> | Made</SPAN> | ||||||||
1679</SPAN> | COOKEVILLE</SPAN> | Made</SPAN> | ||||||||
1680</SPAN> | IRVING</SPAN> | Made</SPAN> | ||||||||
1681</SPAN> | KALAMAZOO</SPAN> | Made</SPAN> | ||||||||
1682</SPAN> | LAWRENCE</SPAN> | Made</SPAN> | ||||||||
1683</SPAN> | LYNCHBURG</SPAN> | Made</SPAN> | ||||||||
1684</SPAN> | MOOSIC</SPAN> | Miss</SPAN> | ||||||||
1685</SPAN> | RALEIGH</SPAN> | Miss</SPAN> | ||||||||
1686</SPAN> | SPRINGVILLE</SPAN> | Miss</SPAN> | ||||||||
1687</SPAN> | SULPHUR SPRI</SPAN> | Made</SPAN> | ||||||||
1688</SPAN> | TANEYTOWN</SPAN> | Made</SPAN> | ||||||||
1689</SPAN> | VERNON</SPAN> | Made</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=4><COL><COL><COL><COL><COL></COLGROUP>