Could you not add an additional criteria to also check the size of the team by using count and seeing if its more than 1, and if not then use the Team Target for the team member
I could, but I think I would end up with the same problem.
The user has selected ALL team members in the quick filter, because they need to see how the team is performing against the Team targets
But there is only 1 team member in the data set because there is no data yet for other team members.
The count of Team Members in my data set will be 1 - so the target for this Team-member will be returned which in this case will not be correct.
So I guess the question is:
How can I differentiate between:
1. There is 1 Team Member in my data set because the user has selected this specific Team Member in the quick filter -> Display Team Member's target.
2. There is 1 Team Member in my data set only because there is no data from other Team Members -> Display Team's target.
Hope the above makes sense.
Is there a way you could supply a packaged workbook?
I have attached a workbook.
What I am trying to achieve is: whenever the user selects in quick filter Team Members:ALL then the Team target (2000) is displayed so they can see how the whole team is performing against the team target.
And when they select a specific team member to see the target for that specific team member.
In quick filters if you select month: February and Team Members: ALL the Team target (2000) is displayed which is what I want.
But if you select month March and Team Members: ALL, it returns the target for that team member (because there is data only for 1 team member for that month)
example.twbx 25.7 KB