3 Replies Latest reply: Oct 29, 2013 5:54 AM by Yevgeniy Popov RSS

    Adding 2 different sets

    Steve Zagzebski

      This should be so simple but I am drawing a blank

       

      I have:

       

      Product

      A

      B

      C

      D

       

      Region

      North

      South

      East

      West

       

      I want to add set analysis like below but it doesn't seem to work:

       

      =sum(
      {<
      [Product]={'A','B'}>}
      Sales
      )

      +

      sum(
      {<
      [Region]={'North','South'}>}
      Sales
      )*.4