0 Replies Latest reply: Jun 13, 2012 2:48 PM by Kevin Bertsch RSS

    Sums for expression in straight table?

    Kevin Bertsch
      SalesNameCustomerStart DateAction DateQuickMediumLong

      Jack

      ABC1/5/20121/6/2012100
      JackABC1/5/20121/25/2012001
      JillXYZ1/5/20121/5/2012100
      JillXYZ1/5/20121/6/2012100
      JackABC1/15/20121/25/2012000
      JamesBBB1/15/20121/29/2012010
      Here's my issue: I have a group of ten salespeople. I want to measure how quickly they respond when they get a lead. I have a straight table, as shown above. The fields "Quick", "Medium", and "Long" are calculated using an expression (NetWorkDays). I want, for each rep, to do a count distinct of company, a count distinct of Start Date per company, and a count of Quick, Medium, and Long. This will, I hope, tell me for each rep the number of companies they are working, the number of opportunities they have, and how many total calls they have made that fall into each of the Quick, medium, and long buckets. I've tried doing this as a pivot table, but it won't let me sum on the expressions, and when I tried a partial sum for Company, it didn't show any sums for Quick, Medium, or Long. I should think this would be simple - it'd take me a minute in Excel - but clearly I'm missing something here. Any help?