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 |
All times are GMT +1. The time now is 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com