1 2 Previous Next 15 Replies Latest reply on Jan 21, 2016 9:03 AM by paul.vanblokland

    Calculation of subgroup criteria

    paul.vanblokland

      Hi all,

       

      I need a calculation with checks a criteria in a subset.

       

      I have the following dataset:

       

      StoreId
      Product
      1x
      1y
      1y
      2y
      2y
      2z
      3y

       

       

      I want to know how many times y occurs in a store where also X occurs. And how many times Y occurs where X does not occur.

       

      The result will look like this

       

      Product
      Times with XTimes without X
      Y23

       

      I think i have to look for a "level of detail"  expression. But i'm not sure.

       

       

      Thanks in advance.

      Paul

        1 2 Previous Next