beginexcel
New Member
- Joined
- Mar 3, 2016
- Messages
- 3
Hi,
I have numbers of employees and their performance %.
I need to find out the % a team is meeting the target.
Say if target is 70%. I need to first count how many employees in Team A is meeting 70%.
Then I am dividing that number with the total employees in the Team A. This will get me the % of team meeting the target.
So normally I would just do.. =countif(C2:C5,"<=.75")/2. To find TeamA's % team meeting. However, I am having trouble doing that in the PowerPivot calculated field. There's no countif. Please teach me!! Thanks so much
Example,
Raw data may look like this
Team Name
Team A
Team A
Team B
Team B
I have numbers of employees and their performance %.
I need to find out the % a team is meeting the target.
Say if target is 70%. I need to first count how many employees in Team A is meeting 70%.
Then I am dividing that number with the total employees in the Team A. This will get me the % of team meeting the target.
So normally I would just do.. =countif(C2:C5,"<=.75")/2. To find TeamA's % team meeting. However, I am having trouble doing that in the PowerPivot calculated field. There's no countif. Please teach me!! Thanks so much
Example,
Raw data may look like this
Team Name
Employee Name
KPI Team A
Employee1
80%Team A
Employee2
60%Team B
Employee3
70%Team B
Employee4
55%
