Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Yearly results with cross tab

Status
Not open for further replies.

bluenet1

Programmer
Nov 22, 2011
10
US
Hello,

I'm working on a current cross tab report that shows results by month for what ever date range selected (multi-year).

I would like to have it show results by month by year.

Thanks in advance for your assistance.
CRXI
 
Add the date field a second time->group options->on change of year. If you want the months nested within years, add year as the first column. If you want to show all years within each month, add year as the second column field.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top