Calculate % variance between 2 total columns in pivot table

[richoking]

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.

	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>

 

[jakeman]

can you provide a table sample of what your source data looks like, by recreating it in the Go Advanced feature?