Pivot table Calculated Field - Is this possible?!

Hello,

I am trying to create a pivot table with a calculated field that would effectively divide Loads & Other Labor Costs by Contract hours to get Loads & Other Labor Costs per hour.

See picture.
[ATTACH=CONFIG]57582[/ATTACH]

I don't know if this is possible since they both sit within the Metrics field?

any help would be awesome.

Thanks!

Re: Pivot table Calculated Field - Is this possible?!

Are sumifs possible in calculated fields? Could I use something like this? So far it's not working

[TABLE="width: 60"]

[tr]

[TD="width: 60"]=IFERROR(SUMIFS(B3:B7,A3:A7,"Loads & Other Labor Costs")/SUMIFS(B3:B7,A3:A7,"Contract Hrs"),0)[/TD]

[/tr]

[/TABLE]