8 Replies Latest reply: Feb 19, 2013 8:41 AM by fredrik.tham RSS

    Intersection of dimension in chart?

    fredrik.tham

      Hello,

       

      I'm trying to create a chart that only contains the products that have been sold every year. Consider this simple example:

       

      Year     Product     Sale

      2008     A               1

      2008     B               1

      2009     A               1

      2010     A               1

      2010     B               1

      2011     C               1

       

      The result I''m looking for is:

       

      Year     Product     Sale

      2008     A               1

      2008     B               1

      2010     A               1

      2010     B               1

       

      It seems to be a simple union but having tried every possible, except the right one, set analysis trick in the book and can't get it to work. Any suggestions?

       

      Thanks

      Fredrik