Hello,

I wish to group a measure (Hours of Service) by Employee and date so that irrespective of the HOS incidents, an employee must be shown only 1 HOS per day.

So, basically I need to Take the min (HOS) per employee per day.

Then, I wish sum the measure obtained above to get the data per region or any other grain.

I have tried using Subtotals, Grand totals but unable to find out how to hide the subtotals and everything else but the Total per Region.

The packaged workbook is attached below.

Any help on this issue is highly appreciated.

Thanks,

Varun