2 Replies Latest reply: Feb 21, 2018 10:21 AM by Wanyun Yang RSS

    dividing a dimension in pivot table

    Wanyun Yang

      Hi guys,

       

      I created a pivot table in Clik Sense like this. This is a record of a sales rep with 2 visit dates(01-12,01-15) and 3 sales quote dates(01-12,01-15,01-16) in total. The bolded dates are the visit dates, the unbolded are the sales quote dates.

      Capture.PNG

      Now I want to put sales quote date 01-12 under visit dates 01-12, sales quote date 01-15 and 01-16 under visit dates 01-15. The result should be like this:


      -2018-01-12

      2018-01-12

      -2018-01-15

      2018-01-15

      2018-01-16

       

      Is it possible to do that? Thanks for help!