17 Replies Latest reply: Jul 21, 2014 4:27 AM by Petter Skjolden RSS

    AND in set analysis

      hello community,

       

      I've got a problem with a set analysis.

      I'd like to get all records of companies which use the combination of 2 products, NOT only one of the products.

       

      Example (does not work I know):

       

      1. product:

      =sum({<articleNr={111}>} numberOfLicences)

       

      2. product:

      =sum({<articleNr={222}>} numberOfLicences)

       

      As information, my data model looks like this:

       

      company as dimension table

      calendar as dimension table

      products as transaction table

       

      Does anyone know how to solve this?

      Thanks in advance!

       

      Regards,

      Carl