We help IT Professionals succeed at work.

How can I have 2 groups in a Matrix with different time range?

JS56
JS56 asked
on
Medium Priority
204 Views
Last Modified: 2012-05-11
I need a matrix for 2 groups (Department - ‘Nursing’ and ‘Other’) What I am doing is showing the Days/Hours they worked for the time frame they select. If they fall into the Nursing Group I need the hours Grouped into 3 shifts but if they fall into the ‘Other’ group the hours are grouped by the day only. Each group needs subtotals and I need a grand total for both Groups.

I also need 2 empty rows after each Group subtotal which will be used for calculations once the report is exported to Excel.

Please see attached spreadsheet.

Sample-Hours-Spreadsheet.xlsx
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.