how to aggregate months as quarter to get aggregated volume?

[udaya_kumar]

Hi,

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?

[#2]

I do have similar kind of a problem.

I have YearQuarter column and the value looks like '2012 Q2'. Once I select 2012 Q2 I need to show Sales for prior 3 quarters, right now I am able to achieve this by selecting 'Datefield' ex: 04/19/2012 but not with 'YearQuarter' field. Pls reply me if any resolution...