View Single Post
  #1   Report Post  
boris
 
Posts: n/a
Default pivot table % calculation

Have the following grouping:

Reporter
Task
Time Spent

where Time Spent is a calculated field. I want to have
the data for each task to be 1) the time spent on that
task (currently showing) and 2) the percent of the
Reporter's time which that task represented.

I am running into trouble trying the different options
for the second data field I set up (just copied the
formula from Time Spent and called it "Time Spent %").
Thought that there was an easy way to turn the 2nd data
field into a "% of the total of the first grouping's
total" sort of calculation.

Any advice?

Boris