New but learning!.
I am trying to do a complicated report but I am breaking it down to some manageable questions piece by piece. I have a table for Work orders. I need to start my report by listing all the different departments with in the Work Order Table whit a count of how many work orders by department .. then for each Department a sub report of the different status of Work Orders and count. It seems simple but i keep on getting a count of 1.

What I have done:
Started a new report
Added in WOCATEGORY (Departments)
     -selected that field and chose the sigma button to
     sum that field
Added a sub report
     - addded in WOCATEGORY
     - added in STATUS
     - chose Select Expert and chose {Status} =
       "Closed"
     - Chose STATUS and selected that field and chose
       the sigma button to sum that field
Added a sub report
     - addded in WOCATEGORY
     - added in STATUS
     - chose Select Expert and chose {Status} =
       "OPEN"
     - Chose STATUS and selected that field and chose
       the sigma button to sum that field

What i end up with is list of all my departments with no count, status of closed with not count and a status of open whit a count of 1?

I need to list all the differet types of Work Orders not just open and closed as well...?
Thanks for you help!

Thank you so much for your response. IF i do not use sub reports what you you suggest to use?

This is what worked for me with some help..

the insert summary button (Sigma button) and
pick the field as WorkerID
Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each group footer that you select. You can drag it into the header group header.

You can see the whole conversation here: https://bit.ly/2Faygnq