1 Reply Latest reply on Nov 2, 2018 9:02 PM by swaroop.gantela

    issue: customer order a category/brand/manufacturer for the first time

    Patrick Weber

      Is it possible to create a calculation which shows me all customers who ordered a product or a category for the first time? I need a filter where I can see which customer orders this month or last etc a product/ a brand for the first time ever. I attached the superstore example workbook In this example e.g. Mr. Unger ordered something of category "Technik" on April 9, 2016 for the first time. And another example: Mr. Unger ordered sth. of manufacturer "Hon" on Sep 28, 2016 for the first time.

       

      Thanks for any hints.