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.