Pivots: Grouping two fields (year, month)

[John]

My pivot table contains two fields I need grouped: "Fiscal Year" and
"Fiscal Month." Both field are numeric, not dates. The grouping would
be like this:

Fiscal Year (2003) and Fiscal Months (9-12)
GROUPED WITH
Fiscal Year (2004) and Fiscal Months (1-3)

Is there a quick way to do this within the pivot? If you group the
"months", the table groups all the months regardless of
"year"....can't figure this one out.

TIA...

 

[Bernie Deitrick]

John,

The easiest way would be to have another column in your data table
indicating the desired grouping: you could use a formula to do it, given
starting and ending dates.

HTH,
Bernie
MS Excel MVP