Use summary reports for a new set of HR questions. Select the grain before the measure. A count of positions can't substitute for headcount, and average salary can't substitute for total salary. Keep those measures labeled so an exported workbook retains its meaning.
Some groups have no matching rows. Preserve the requested filter instead of broadening it to force a number. Components with different populations can share an organization grouping, but they still need independent validation. The exercises revisit column groups, blank relationships and detail inspection. Choose an Advanced register when the consumer needs individual IDs, and a Matrix when the consumer needs totals. A familiar report type is useful only when its output answers the stated question.