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