Pivots: Grouping two fields (year, month)

  • Thread starter Thread starter John
  • Start date Start date
J

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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding fiscal years ... 5
Access 2 Digit year in Access Text Box 3
End of Quarter Based on Fiscal Year 2
To automatically give fiscal period/fiscal year 7
Fiscal YTD Filter 7
Cash Statement- Accruing balances 1
Group by fiscal months 5
Get fiscal year to show in a report 4

Back
Top