Is there a way to calculate percentage via Pivot Grid

Hi Everyone,

I am working on my first pivot grid. My predicament is how to calculate the turnover rate (# of terminations / # of employees). My data in the table looks like this:

Bus Unit     Department     Job Code     # of Terminations     # of Employees     Turnover Rate

ABC          ABC123          JC123          10                              20                           .50

ABC          ABC123          JC456           10                              20                          .50

I wrote a simple PS Query using the table above and used the Pivot Grid wizard to create the Pivot Grid.

In my Pivot Grid, when I filter by Department ABC123 for all Job Codes, it shows like this:

ABC          ABC123                                20                              40                         100%  (shows Turnover rate as 100 % because it is adding 50% + 50%; the correct Turonver should be 50%)