Forum Discussion

anoomohan's avatar
anoomohan
Icon for Helper III rankHelper III
2 years ago
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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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

anoomohan's avatar
anoomohan
Icon for Helper III rankHelper III
2 years ago

means 10 active staff and 2 inactive staff that month - not sure i am getting ur question though

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

are we looking at the Jun -23 or Jun -24? if Jun-23(the first column), I only see one IN. If Jun-24, I didn't see any IN in that column.