This content has been marked as final.
Show 2 replies
-
Re: dividing a dimension in pivot table
Stefan Wühl Feb 20, 2018 5:50 PM (in response to Wanyun Yang)How does your data model look like?
Looks like your sales quote and visit tables are not connected, is this true?
-
Re: dividing a dimension in pivot table
Wanyun Yang Feb 21, 2018 10:21 AM (in response to Stefan Wühl )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.
-