2 Replies Latest reply: Feb 27, 2018 12:20 PM by Wanyun Yang RSS

    FORMULA IN PIVOT TABLE

    Wanyun Yang

      Hi guys,

       

      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:

      -1-10

        1-12

      -1-20

        1-23

       

      Can anybody help me with the formula?

       

      Thanks!