I wanna present Sales achieved against the Target for each Salesman & show the percentage achieved. When i try to present it on pivot chart i am not able to get the correct percentage on Bar graph
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
SalesMan | Sales | Target |
Santner | 3500 | 6000 |
Turkish | 3200 | 6000 |
Billy | 1500 | 4000 |
Mccullum | 700 | 6000 |
Johana | 1600 | 4000 |
Janice | 500 | 6000 |
Amy | 0 | 4000 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>