7 Replies Latest reply: Apr 26, 2013 11:28 AM by Nicolas Agrapart RSS

    Help with market basket Analysis

      Hello

       

      I am working on a project of MBA and I am stuck on a formula.

      I want to create a table with all the product sold and for each one the value of the basket where they are.

      I am able to get the first measure:

       =COUNT({<Product= >}DISTINCT NoBasket)
      

      But first the second  I am not able to build it. I tried a lot of formulat like

      =SUM({<NoBasket=P({<Product= >} NoBasket), Product= >} Amount)
      

      but it does not work, it gives me the value of the product for the basket not the value of all the basket where it is.

       

      Does anyone have any idea ?

       

      Thanks for your help