1 Reply Latest reply: Apr 21, 2010 5:39 AM by Manuel Rühl RSS

    Set analysis, If customer purchase one of the product groups/ Proritization

    beciafreestyle

      Dear QV user,

      I would like to ask for some help. I need to prioritize customers that purchase one of the three product groups (ex. proteins or calcium or magnesium). I thought I can do it by usage of set analysis, but cannot come with proper formula. I would like to include in a table extra column, that says 'yes' if customer purchased proteins or calcium or magnesium, otherwhise 'no'. Any ideas? Customer name is my dimension.

       

      Thank you in advance,

      Beata