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!