X
xrbbaker
I have raw data like this showing what % of their time was involved on a
project.
JAN FEB MAR
A Tom .25 .5
A Sam .25 .4 .5
A Phil .25 .5 .5
A Pete .5 .5 .75
B Sam .1 .4 .5
B Tom .4
I want to show the total of how many unique people were involved across all
projects each month. If they were involved anything > 0, then that counts.
Thus the desired output would be:
JAN FEB MAR
TOTAL 4 3 4
I put a formula in the raw data so that it is either a 1 or 0. I can make a
pivot table using the raw data. The PT groups the people, but then sums the
raw data, (as it should) ending up with double counting for my purposes.
JAN FEB MAR
Tom 1 2
Sam 2 2 2
Phil 1 1 1
Pete 1 1 1
TOTAL 5 4 6
How can I set things up so that I only count a person once, even if they
worked on 2 different projects during the same month?
Thanks - Russ
project.
JAN FEB MAR
A Tom .25 .5
A Sam .25 .4 .5
A Phil .25 .5 .5
A Pete .5 .5 .75
B Sam .1 .4 .5
B Tom .4
I want to show the total of how many unique people were involved across all
projects each month. If they were involved anything > 0, then that counts.
Thus the desired output would be:
JAN FEB MAR
TOTAL 4 3 4
I put a formula in the raw data so that it is either a 1 or 0. I can make a
pivot table using the raw data. The PT groups the people, but then sums the
raw data, (as it should) ending up with double counting for my purposes.
JAN FEB MAR
Tom 1 2
Sam 2 2 2
Phil 1 1 1
Pete 1 1 1
TOTAL 5 4 6
How can I set things up so that I only count a person once, even if they
worked on 2 different projects during the same month?
Thanks - Russ