Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and Job

Summary:

Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Your expert suggestions or report sharing would be most appreciated. FYI - We do not use Positions yet. I tried the WFM-Vacancy Real Time subject area without success. Thank You!

SAMPLE EXPECTED OUTPUT

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):