6 Replies Latest reply on Feb 23, 2016 10:02 AM by Wing Nguyen

    How to set up numeric order on a cross tab

    Wing Nguyen

      Hi there,

       

      I want to be able to show the numeric order of the deal signed starting from the beginning of the year on my crosstab. Can you show me how to set that up as a calculated field. I thought that I can use Index but it doesn't work the way I want it to appear. Please see the same below with workbook. I want the data to look like the Deal column from my example. Thank you!!

       

         

      Deal IDDealProduct IDMarketing Rep
      1231234Mary
      456Mary
      678Mary
      1252777John
      3453454Maggie
      555Maggie
      4334666John