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 https://jetsupport.jetreports.com/hc/en ... 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 http://support.jetreports.com. Staff responses to posts on the forum are not guaranteed.
YJury
Posts: 20
Joined: Wed Sep 09, 2015 9:56 am

Group by calculated column?

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

Hello,
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
HPDeskJet
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
-HP
_______________________
Jet 2015 Certified Trainer


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 14 guests