please help I wish to create a VBA pivot for all employees, with sum of wages and calculated field of wages plus bonus, the calculated field bonus percentage should change according to the row category of employees

It should be like below for clerk it should be 5%, coordinator should be 10% etc..

sum of daily wages | Wages + Bonus (calculated field) | |

clerk | 1000 | 1050 |

Coordinator1 | 1000 | 1100 |

Coordinator2 | 1000 | 1100 |

Coordinator3 | 1000 | 1100 |

Controller | 1000 | 1200 |

Manager | 1000 | 1300 |