Group by calculated column?

Questions and Answers asked by users to users, about how others use Jet Reports.

For additional "how to" information, please visit our online Knowledge Base ... ofessional
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at Staff responses to posts on the forum are not guaranteed.
Posts: 20
Joined: Wed Sep 09, 2015 9:56 am

Group by calculated column?

Postby YJury » Tue Apr 25, 2017 12:20 pm

I want to group a report by the month of a date field. I thought maybe I could use the =month() function in Excel and then group by that column, but I can't figure out if that's possible. The report is currently grouping by date, but I want to group by the month of the date instead. So instead of grouping by 6/25, 6/26, 6/27, etc. I want to group by June. How can this be accomplished?

User avatar
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: Group by calculated column?

Postby HPDeskJet » Tue Apr 25, 2017 1:35 pm

Here's how I'd do it:

1 - Design.png
(click image to enlarge)

resulting in:
2 - Results.png
Jet 2015 Certified Trainer

Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 14 guests