4 Replies Latest reply: Feb 10, 2013 2:58 PM by kevin cool RSS

    help with aggr function

    kevin cool

      hi,

           I have a staright table with 'month year'sales.png and sum(sales)

       

      For each monthyear i want to know the corresponding last year quarter sum of sales.I want to add a row beneath which specifies this total.for example underneath may 2011 the value will be sum(sales) for apr 2010+may2010+jun 2010,underneath jun 2011 it will be same and changes for july since its different quarter.Any ideas plz.