2 Replies Latest reply on Jul 20, 2017 8:52 AM by Varun Vasudevan

    Group a Measure by a dimension and then Aggregate it

    Varun Vasudevan



      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.