pivot table % calculation

B

boris

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top