Group Revenue by Month
Group closed won revenue by owner and by month with the date grouping of the Pivot Table, month names in full, so a sales director sees who closed what when.
A sales director reviews closed won revenue once a month: who brought it in, and in which month. Grouping Close Date by month gives one column per month, with the owners down the side and the yearly total of each rep on the right.

Before you start
A Pivot Table on Opportunity. Summarize Pipeline by Stage and Quarter builds one; you can reuse it or start a new component the same way.
Opportunities in the Closed Won stage this year, with an Amount.
Steps
Group the close dates by month
Set the only item of Group Columns to Close Date.
Group: Month.
The Group list decides how dates are bucketed:
Year
Several years side by side
Quarter
One year, by quarter
Month
One year, by month
Week
One year, by week
Day
A short range, such as one month
Year-Quarter
A range longer than a year, by quarter
Year-Month
A rolling twelve months
Note: Month alone puts January of every year in the same column. The query is limited to this year, so that is what you want here. For a range that crosses a new year, pick Year-Month.
Troubleshooting
Related tutorials
Summarize Pipeline by Stage and Quarter: the base table, by stage and quarter.
Filter and Export a Pivot Table: filter by lead source, then send the table to Excel.
Was this helpful?

