10 Replies Latest reply: Apr 19, 2012 4:19 AM by shrkntnqv RSS

    how to aggregate months as quarter to get aggregated volume?

    Uday Kumar



      i have a field known as 'Month Name',

      the data for this looks like, jan 2005, feb 2005, mar 2005 till.... dec 2011

      In the pivot table, i will show these values as column, by dragging this field to top.

      so it looks like the attached image.

      but now i want to show 3months volume as single column in table like

      jan 2005, feb 2005, mar 2005 volume will be aggregated and it should show as one column 'quarter1'.

      like wise, i have to do for every 3months sum, i need to show as a column in table

      how we can achieve this?