2 Replies Latest reply on Aug 9, 2017 9:47 PM by T G

    Unique data on Dimension Level

    T G

      Hello Members,

       

      Hope you all are enjoying the day.

       

      I need your help to get solution of my problem. Below is the snapshot of data and sample workbook 10.1 is attached.

       

                                              

      Job Work UnitMinutes
      112:28
      122:28
      132:28
      112:29
      122:29
      142:29

       

      Expected result is below, i want result as count of unique workunits on minutes level.

       

                      

      MinuteCount (Work Unit)Include (Comment)
      2:2831,2,3
      2:291only 4 as 1,2 are in 2:28

       

       

                                              

      Job Work UnitMinutes
      112:28
      122:28
      132:28
      112:29
      122:29
      142:29