# Group By Option in Reporting **URL:** \ **Category:** HubSpot Ideas\ **Created:** [July 9, 2020, 8:06am UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643 "2020-07-09T08:06:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mark\_poyser](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mark_poyser/32/58551_2.png) [@mark\_poyser](https://community.hubspot.com/u/mark_poyser)\ **Post date:** [July 9, 2020, 8:06am UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/1 "2020-07-09T08:06:31Z")
Hi, Not sure if anyone else has come from Salesforce on here, but from reporting aspect it was very strong, with many options for configuring reports. On the options was ‘group by’ in reporting. I would say that this is where Hubspot has a weakness in the reporting. As an easy to explain example. If you wish to show Contacts by Company in a report and display each of the Contact names per company, the result in Hubspot is that the Company name appears in the list for every contact. With ‘Group By’ this break the report up into sections by Company, with the Contacts listed below in a section. This would repeat for every Company. There are so many options for this functionality, including displaying data by month, qtr, year etc Unless I am missing something. This does not appear to be possbile currently Hubspot Dev Team, please add this function ---
**Author:** ![MissTipsi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/misstipsi/32/44503_2.png) [@MissTipsi](https://community.hubspot.com/u/MissTipsi)\ **Post date:** [July 10, 2020, 6:46am UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/2 "2020-07-10T06:46:43Z")
SF reporting is light years ahead of Hubspot unfortunately. No OR reporting, severe limitations around relative dates and inability to do left/right joins etc. ---
**Author:** ![JamesNichols90](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jamesnichols90/32/26012_2.png) [@JamesNichols90](https://community.hubspot.com/u/JamesNichols90)\ **Post date:** [June 18, 2021, 3:38pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/3 "2021-06-18T15:38:05Z")
Yes!!! This is exactly what I have been looking for and, in my eyes, is HubSpot’s biggest reporting flaw. We run activity reports to show activities attached to deals. We would love to group the deals in each deal stage. Then we could see all of the deals in each stage and all of the sales activity related to said deals. ---
**Author:** ![JamesNichols90](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jamesnichols90/32/26012_2.png) [@JamesNichols90](https://community.hubspot.com/u/JamesNichols90)\ **Post date:** [June 18, 2021, 3:41pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/4 "2021-06-18T15:41:24Z")
![Report 1.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/e/5e5f1f66aa3742f0d3826105ed78c6859324ba9b.png) There is this “break down” option, but it dissapears when you want your report configured as a “Table”. ---
**Author:** ![JamesNichols90](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jamesnichols90/32/26012_2.png) [@JamesNichols90](https://community.hubspot.com/u/JamesNichols90)\ **Post date:** [June 18, 2021, 3:42pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/5 "2021-06-18T15:42:57Z")
![Report 2.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/2X/8/85fd52b0536dd7fe607d4aac44e7d26e833d7876.png) Here is an example of a report in Salesforce for the folks at HubSpot Here is an example of the report from the folks at HS. As you can see the rows can be grouped multiple times. ---
**Author:** ![JamesNichols90](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jamesnichols90/32/26012_2.png) [@JamesNichols90](https://community.hubspot.com/u/JamesNichols90)\ **Post date:** [June 18, 2021, 4:56pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/6 "2021-06-18T16:56:39Z")
@hubSpotDev ---
**Author:** ![AGoletti](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/agoletti/32/79644_2.png) [@AGoletti](https://community.hubspot.com/u/AGoletti)\ **Post date:** [July 29, 2021, 9:21am UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/7 "2021-07-29T09:21:38Z")
If the reporting worked as it does in Salesforce this system would be perfect. ---
**Author:** ![KMace](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kmace/32/5125_2.png) [@KMace](https://community.hubspot.com/u/KMace)\ **Post date:** [September 2, 2021, 9:52pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/8 "2021-09-02T21:52:44Z")
I need the ability to group in reports. By numbers, dates, status, etc. ---
**Author:** ![DanielMolina](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danielmolina/32/18373_2.png) [@DanielMolina](https://community.hubspot.com/u/DanielMolina)\ **Post date:** [October 21, 2021, 10:45pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/9 "2021-10-21T22:45:52Z")
I was able to group contacts under companies by using Pivot Table under Custom Report Builder ---
**Author:** ![SZinken](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@SZinken](https://community.hubspot.com/u/SZinken)\ **Post date:** [January 14, 2022, 9:17pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/10 "2022-01-14T21:17:44Z")
Has anyone heard anything more about this? I’m trying to create pivot table in order to have a report that shows contacts organized by company. ---
**Author:** ![ashfaqshaikhjr](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@ashfaqshaikhjr](https://community.hubspot.com/u/ashfaqshaikhjr)\ **Post date:** [March 4, 2022, 12:59pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/11 "2022-03-04T12:59:56Z")
Need this feature ---
**Author:** ![Ceridwen1971](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ceridwen1971/32/44643_2.png) [@Ceridwen1971](https://community.hubspot.com/u/Ceridwen1971)\ **Post date:** [April 8, 2022, 12:26pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/12 "2022-04-08T12:26:06Z")
This is a must for us. We are coming from SalesForce and my Sales Team is pushing back on the implementation because of the lack of being able to add a third row option on the pivot table reports in HubSpot. Definately a MUST! ---
**Author:** ![DMcBeth](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dmcbeth/32/81360_2.png) [@DMcBeth](https://community.hubspot.com/u/DMcBeth)\ **Post date:** [June 8, 2022, 11:27pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/13 "2022-06-08T23:27:58Z")
This would be amazing to have. I am surprised it is not a feature after a couple of years since this was submitted. ---
**Author:** ![KDale](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@KDale](https://community.hubspot.com/u/KDale)\ **Post date:** [June 8, 2022, 11:35pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/14 "2022-06-08T23:35:37Z")
Agreed with those above. This is an absolute must have and I hope it’s prioritized very soon. ---
**Author:** ![OSegall6](https://avatars.discourse-cdn.com/v4/letter/o/59ef9b/32.png) [@OSegall6](https://community.hubspot.com/u/OSegall6)\ **Post date:** [December 16, 2022, 4:03pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/15 "2022-12-16T16:03:37Z")
NEED THIS! ---
**Author:** ![WSmith5796](https://avatars.discourse-cdn.com/v4/letter/w/d78d45/32.png) [@WSmith5796](https://community.hubspot.com/u/WSmith5796)\ **Post date:** [January 31, 2023, 7:34pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/16 "2023-01-31T19:34:09Z")
Agreed! A “Group By” is a common reporting element in many applications (heck - Outlook View Settings). It allows you to build table-based summary reports of many types. In SalesForce, I would group and then summarize Deals month or quarter. Please add! ---
**Author:** ![AJohnsson](https://avatars.discourse-cdn.com/v4/letter/a/ecb155/32.png) [@AJohnsson](https://community.hubspot.com/u/AJohnsson)\ **Post date:** [April 14, 2023, 11:43am UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/17 "2023-04-14T11:43:53Z")
Coming over from Salesforce this is probably the functionality I miss the most. Please make this happen. ---
**Author:** ![SReuven](https://avatars.discourse-cdn.com/v4/letter/s/f6c823/32.png) [@SReuven](https://community.hubspot.com/u/SReuven)\ **Post date:** [June 6, 2023, 2:13pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/18 "2023-06-06T14:13:43Z")
Same here - I can’t believe I’m saying this but this simple feature makes SFDC better ---
**Author:** ![AInkster](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@AInkster](https://community.hubspot.com/u/AInkster)\ **Post date:** [June 7, 2023, 2:44pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/19 "2023-06-07T14:44:18Z")
same - has anyone found a way to group accounts by a column? ---
**Author:** ![MZelasko](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mzelasko/32/45305_2.png) [@MZelasko](https://community.hubspot.com/u/MZelasko)\ **Post date:** [August 10, 2023, 1:39pm UTC](https://community.hubspot.com/t/group-by-option-in-reporting/22643/20 "2023-08-10T13:39:59Z")
My team would **love** this so much [Next page](https://community.hubspot.com/t/group-by-option-in-reporting/22643.md?page=2)