Summing of Different sites within a day

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

Hello! I have an employee attendance database for 2 sites, FL and AZ. My
report is sorted first by date, then by site then by reason (there are 8,
e.g. "Vacation")

I have a sum in each Reason footer that gives me the total number of hours
everyone at that site was out for a particular reason.

I also have a sum in each date footer that gives me the total number of
hours everyone at both sites was out for all reasons.

What I need is this sum in the date footer to be broken up by Reason,
regardless of site.

Thank you for your help!
 
I don't get how a "Sum" can be broken up by anything - you surely mean that
the next level of grouping after Date is Reason? I've struggled to get my
head around this, but it sounds to me that you are trying to make one report
do the job of two. Surely you need a separate report which either omits the
grouping by site or reverses the last two groupings, so it's grouped by
Date, by Reason and then by Site? Of course, you can have both reports
available.


Phil, London
 
Back
Top