I have to count number of Billed Employees.For this i have data like
A Particular Employee is Allocated to different projects in which some are Billability "Y" and some are "N".
I want to add a member in Account dimension like Billed_Count to be taken as 1 if the Employee having Billability "Y" in atleast one Project for Distinct Employee. I have to see overall headcount of Billed Employees at different head levels like Grade wise, Project wise, Vertical wise...
How can i overcome this scenario. I tried in different combinations but i haven't get what i expected. Please help on this.
Thanks in Advance,
In the example E1 has two Ys so will the account be 1 or 2?
Count is an option that you can look at.
Your explanation is little confusing is that distinct Employee for each project or distinct project for each employee?