Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
How does your data model look like?
Looks like your sales quote and visit tables are not connected, is this true?
There is a sales quote table recording customer_No and sales quote date, and a visit table recording customer_No and visit date. The tables are connected by customer_No, which I used as the first dimension in this pivot table. These visit dates and sales quote dates are the second and third dimensions.