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.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Mon
hr spent[/TD]
[TD]Mon
bill hrs[/TD]
[TD]Tue
hr spent[/TD]
[TD]Tue
bill hrs[/TD]
[TD]Wed
hr spent[/TD]
[TD]Wed
bill hrs[/TD]
[TD]Tot
hr spent[/TD]
[TD]Tot
bill hrs[/TD]
[TD]% vari[/TD]
[/TR]
[TR]
[TD]w/c 180806[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]30[/TD]
[TD]24[/TD]
[TD]xxx[/TD]
[/TR]
[TR]
[TD]w/c 180813[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]xxx[/TD]
[/TR]
[TR]
[TD]w/c 180820[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]30[/TD]
[TD]6[/TD]
[TD]xxx[/TD]
[/TR]
[TR]
[TD]w/c 180827[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]27[/TD]
[TD]27[/TD]
[TD]xxx[/TD]
[/TR]
</tbody>[/TABLE]

 

[jakeman]

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