Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table % calculation | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |