Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05:32 PM
pivot table yllee70 Excel Worksheet Functions 1 February 21st 05 10:49 PM
Removing errors from a Pivot table Mighty Magpie Excel Discussion (Misc queries) 2 February 3rd 05 03:15 PM
Pivot Table % calculation CSAH Excel Worksheet Functions 1 January 14th 05 04:33 AM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"