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

    Filter on a group and date




      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.