This content has been marked as final. Show 2 replies
I have a raw data table with columns: customer, visit_date, saleswritten_date. Now I want to create a pivot table and put these three columns as three dimensions.
For saleswritten_date, I'm trying to show only those dates not within 7 days of visit_date. For example, for a certain customer:
visit_date 1-10, 1-20
sales_date 1-12,1-18, 1-23, 1-30
Then the result should be like:
Can anybody help me with the formula?