I've tried searching for this specific problem on here and online, with no joy.
I have a bunch of projects laid out and pivoted in line with the below pivot table, showing me Hours Spent and Billable Hours for each day and then in total for the week. I would like to calculate a simple productivity % based on the Total columns only. I can do a Calculated Field but then this applies to every single day, and besides being messy is not useful info to me.
Any help appreciated.
<tbody>
</tbody>
I have a bunch of projects laid out and pivoted in line with the below pivot table, showing me Hours Spent and Billable Hours for each day and then in total for the week. I would like to calculate a simple productivity % based on the Total columns only. I can do a Calculated Field but then this applies to every single day, and besides being messy is not useful info to me.
Any help appreciated.
Mon hr spent | Mon bill hrs | Tue hr spent | Tue bill hrs | Wed hr spent | Wed bill hrs | Tot hr spent | Tot bill hrs | % vari | |
w/c 180806 | 10 | 8 | 10 | 8 | 10 | 8 | 30 | 24 | xxx |
w/c 180813 | 10 | 10 | 10 | 10 | 10 | 10 | 30 | 30 | xxx |
w/c 180820 | 10 | 2 | 10 | 2 | 10 | 2 | 30 | 6 | xxx |
w/c 180827 | 9 | 9 | 9 | 9 | 9 | 9 | 27 | 27 | xxx |
<tbody>
</tbody>