Need help with totals in a pivot table

[diffeyj]

Hi All,

So what I am after seems like it should be simple, but I just can't work out how to do it

I have a pivot table that is simply showing employees hours broken up by the activity they were doing.

So I have 2 expressions:

- Hours: sum(Hours)

- %: sum(Hours) / sum(TOTAL Hours)

I only want the % column to show on the right hand total (ie. total by activity and time type). I don't want it to show for each employee, nor do I want it to show in the totals by employee.

Anyone got any helpful pointers?

thanx in advance

Josh