Back again with a question with excel formula, The earlier formula was used to create a pivot table, which now is successfully created, but from that pivot table i want to create a comprehensive table which gives total of workload per person irrespective of team, i tried to create an another pivot table from the first one but one cell in header is blank, it is not feasible. So i decided to list down the names of person in table 2, but the problem i cannot figure out feasible way to get an automatic update to return me the sums of above also the header should be repeated with out the team/group name.
Enclosing herewith an example sheet... I know this might be frustrating but please do help....