number of working employees and non working employees

[Former Member]

Hi Experts,

I need to create a query which shows Company code wise 'No. of staff(live)' and 'No of staff(rest)' for a particular year(prompt).

Kindly help me for the same.

Thanks and Regards,

Mithilesh

[Loed]

Hi,

Can you post a sample data?

Regards,

Loed

[former_member586947]

Hi Mithilesh,

    What happened to the DOJ of Employee in the report. I think you are querying on the same cube.

If so, consider the present status(Active/Inactive) of the employee and create RKFs accordingly.

Regards,

Satya.

[ccc_ccc]

Hi Mithilesh,

Please use exception aggregation.

https://help.sap.com/saphelp_nw70/helpdata/EN/47/4d6d902dbb22c5e10000000a42189d/frameset.htm

Thank you,

Nanda

[RamanKorrapati]

please repost your issue bex forum instead of here.

you may get more help than here.