8 Replies Latest reply on Mar 27, 2013 11:43 AM by gareth agius

    Aggregate on matching attributes over time.

    gareth agius

      Hi,

       

      So i would like to compute the aggregation of a sales column, and compare the results between one year and another. However i only want to see the aggregation of products that can be found in both years. So lets say i have 10,000 different products, i only want to see the total sales for all those products that where sold in both 2009 and 2010 (so the intersection of products). Doing it manually by filtering is a bit tedious, is there a way of doing this automatically?

       

      Thanks and regards

       

      Gareth