4 Replies Latest reply on Feb 22, 2016 2:22 PM by Wing Nguyen

    How to aggregate number of deals by marketing rep using deal ID

    Wing Nguyen

      Hi there,

       

      I want to ask how I can create a calculated field and aggregate Deal ID so that I can see how many deals are being worked on by each Marketing Rep. The results I expect is to be able to show on the cross tab that Mary worked on 1 deal and John worked on 2 deals.

      Thanks

      Wing

       

      The sample workbook is attached.