Count the number of employees in a group.

Lani Vriezema
Lani Vriezema used Ask the Experts™

I created a date range parameter and grouped the data by employees. My goal is to count the number of employees who worked during a time period. I tried using the count formula for the employee group but it won't let me. Please help
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
What period do you want them counted for?

If it is the entire period of the date range just use


Since you grouped by employee there is only 1 employee in each group.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet Software

Sounds like you grouped by X (employee) but you want to count by Y (e.g. by Day).

You can simply insert a CrossTab grouped by Y.
For more complex cases, you can use a subreport grouped by Y.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial