Getting pivot table to sum averages data to subtotal and grand total on pivot

I have a pivot table that averages hours. The subtotal and grand total on the pivot table are taking the averages of the data on the pivot. I need it to sum the data on the pivot.

I have attached an example.

Any help would be greatly appreciated.

Toni

Hi tonibinga,

Try changing your Value Field Setting in the Value field from Average of Other Hours to Sun of other Hours. Hope this is what you're after.

thank you. my example was too simple. i will redo so it may more sense/

This is a better representation of what I am looking for.

Hope this helps clear up what I am asking.

Sorry,

Toni