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
HI Ryan,
in June 2023 there are 9 active sales staff and 1 inactive, means this guy didnt join the company in June 2023. he joined in Feb 2024 - so he is marked active from Feb 2024. I need some chart or matrix where its possible to see each month count of As and count of INs;
e.g., like below matrix or if there is any visual chart, kindly suggest
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