Forum Discussion
Solved
HR COUNT
HI ALL, I need a simple chart to show the total count of sales staff per month as per below table a- active; in - inactive so for June - total active is 10, inactive is 2 - in a simple matri...
i think you are supposed to have an employeeid or name column.
select that column and unpivot other columns in PQ
then create a dim table.
pls see the attachemnt below
I saw more than 10 As and 1 IN in the first column. Why the total active is 10 and inactive is 2?
could you pls elaborate this?
What's more , could you pls paste the sample data here(not the screenshot)?
active is who are still working, inactive - staff who left
| Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
| IN | IN | IN | IN | IN | IN | IN | IN | A | A | A | A | A |
| A | A | A | A | A | A | A | A | A | A | A | A | A |
same question, how to get 10 for active and 2 for inactive in Jun?