I have a report that shows each associates daily numbers.
this works great when you only have one day to report on. When you want to see more than one day and thus get the sume and the average of all the metrics this is what happens.
How can I create a grouped report that will sum the first four number groups and average the other three so that I can get a weekly or monthly average report?