6 Replies Latest reply on Aug 21, 2013 9:24 AM by Steve Martin

    Filter on a group and date

    yulia.khazanova

      Hello!

       

      Could you please help me to create a calculated field? Please look at the file attached below.

       

      The dilemma is the following:

       

      I have clients [CLIENT] on different days [DAY] of the week: from Monday to Sunday. They buy different products [PRODUCT] each day: Apple, Banana, Bread, Milk, etc.

       

      I need to look only at the clients that buy Apples on Monday, and see what they buy on Tuesday.

       

      Thanks!

      Julia