deer777
asked on
MS Access Pivot Table Distinct Count
I have created a pivot table listing the following information
Team
Team Members
Role
Count of Team Member
What I need additionally is a Distinct Count of Total Team Members because some of the Team Members are on more than one team.
Team
Team Members
Role
Count of Team Member
What I need additionally is a Distinct Count of Total Team Members because some of the Team Members are on more than one team.
can you provide some sample data? and a screen shot of what you have now?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
is there a way I can drop a screenshot into this message box. I am unable to send a file.
ASKER
All data is in the headers of the pivot table with the individual teammember counts at the bottom of each team. Need a distinct teammember count on the far right column of pivot
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can"t send a screenshot or upload a file at this time
ASKER
Created a new team called All Team Members and got the count from that group