4 Replies Latest reply: Nov 24, 2010 5:53 AM by Maria.Delaney RSS

    Creating multiple totals by year by quarter in pivot table

    Maria.Delaney

      I'm trying to take a series a data into a summary table. (to keep things simple [:)] ) I have a date field and a quantity field and need to produce a summary of this data by quarter by year using pivot tables.

      I would like it to look something like the following

       

      2010

      2011

      {total for all of 2010}

      {total for all of 2010}

      Jan-Mar 2010

      Apr-Jun 2010

      Jul-Sep 2010

      Oct-Dec 2010

      Jan-Mar 2011

      Apr-Jun 2011

      Jul-Sep 2011

      Oct-Dec 2011

      {Q1 total}

      {Q2 total}

      {Q3 total}

      {Q4 total}

      {Q1 total}

      {Q2 total}

      {Q3 total}

      {Q4 total}



      Mine usually ends up close to this but usually falls over on the yearly totals, I've tried putting multiple expressions and using partial sums but to no avail.

      Many many thanks in advance for any help anyone can offer me.

      Maria