6 Replies Latest reply: Jul 14, 2012 9:22 AM by Nagaian Krishnamoorthy RSS

    Set analysis Help

      Hi everyone,

       

      I'm trying to make a straight table that shows my 'usergroups', distinct 'TechID's', and those peoples 'ActualTimeReported'.

       

      I want it to sort out by UserGroup but only include distinct TechID's and then sum up the ActualTimeReported for those distinct TechID's.

       

      I tried something like this as my expression...

       

       

      =

      aggr(sum(distinct({$< 'TechID'={}>}TechID)TimeReportedActual)UserGroup)

       

       

      ...With my dimension of Usergroup

       

      Obviously it doesnt work. Any help would be great. Thanks.