Anaplanners,
I have a query on how i can remove double counting of Projects.
Case artifacts:
T1 Teams, which is a hierarchical list, so for example Team A.1 & Team A.2 rolls up to Team A, like wise Team B.1 rolls up to Team B; all rolling up to total teams.
M1 Members: Flat member list.
P1 Projects: a Numbered list of projects.
C1 Business Type: A flat list of different types of businesses involved. Example Manufacturing, Sales, Service.
Each member is assigned with a team and a project. However members from different teams can be assigned to same project. Example, members from Team A.1 and Team B.1 can be working on the same project. Teams can work on multiple projects as well.
Now if i need a pie chart based on C1 business type; where when i select the team, like Team A.1: - i need to get the number of projects in each business type.
I have managed to get the numbers using a sum logic.
Using a simple count line item in a P1 Project module. (CON1 Count )
And in a module dimensioned by T1 & C1; using SUM function, formula goes CON1.Count[SUM: C1 Business Type]
Issue here is the project count doubles when different teams work on the same project, is there a way to overcome this ?
Thanks