# Custom Report Builder **URL:** \ **Category:** Dashboards & Reporting\ **Created:** [January 10, 2023, 11:52am UTC](https://community.hubspot.com/t/custom-report-builder/72529 "2023-01-10T11:52:30Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![DStone1](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@DStone1](https://community.hubspot.com/u/DStone1)\ **Post date:** [January 10, 2023, 11:52am UTC](https://community.hubspot.com/t/custom-report-builder/72529/1 "2023-01-10T11:52:30Z")
Hi all I am new to using HubSpot, and I am running into a couple of problems with the Custom Report builder, that I am hoping someone can help with. I have, successfully, built a report that shows the number of deals and at which stage they are currently sitting it. It is shown using the KPI summary. I am then adding fields (e.g., contact name, email address etc) so that when I click on the number under a stage header, it shows the list of people and the information I have added within the fields section. I am aware that I can create a seperate report to do this for me, but we are capped at certain number of reports and I am trying to save space by doing it this way. Due to the nature of our business, we will almost always have two contacts attached to each deal. How can I get the report to show each contact on the same line, instead of showing the deal on two lines with different contacts? Additionally; the fields appear to be showing in a random order - not alphabtical, and not grouped by contact/deal information. How can I get the report to show fields in the order I selected fields? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 10, 2023, 11:56am UTC](https://community.hubspot.com/t/custom-report-builder/72529/2 "2023-01-10T11:56:43Z")
Hi @DStone1, Happy to help here! > * * * > > @DStone1 wrote: > > How can I get the report to show each contact on the same line, instead of showing the deal on two lines with different contacts? > > * * * As far as I know, this is unfortunately not possible – assuming that you’re referring to a table chart type? > * * * > > @DStone1 wrote: > > Additionally; the fields appear to be showing in a random order - not alphabtical, and not grouped by contact/deal information. How can I get the report to show fields in the order I selected fields? > > * * * Again assuming that you’re using a table chart, the order of the columns follows the order of the fields you’ve dragged here: ![karstenkoehler_0-1673351785437.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/9/d982fa00eecc67d6fa7bebbf36261b0f672aa709.png) By re-arranging the fields, the chart type should reflect the order. Best regards! ---
**Author:** ![DStone1](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@DStone1](https://community.hubspot.com/u/DStone1)\ **Post date:** [January 10, 2023, 12:57pm UTC](https://community.hubspot.com/t/custom-report-builder/72529/3 "2023-01-10T12:57:15Z")
Hi Karsten - thank you for the quick response! I have attached two screenshots to try and make it a little clearer. I am not creating a table chart report, I have created a KPI report and using looking to use the report within this to generate a list of names/data. As mentioned, I’m trying to do this to save space due to our limited number of reports avaliable. You can see in the first picture the order of fields, and the actual order shown in the second. ![Fields1.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/f/cf6608c47c91a7a31b1d6330cd2c8cc224d97238.png) ![Fields2.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/d/fd198c6756edf8e63873bfcffffc8446a8197398.png) ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 10, 2023, 1:01pm UTC](https://community.hubspot.com/t/custom-report-builder/72529/4 "2023-01-10T13:01:25Z")
Hi @DStone1, When you click the pen next to _Deal stage_, you should be able to configure the sorting logic: ![karstenkoehler_0-1673355670665.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/2/020bf248ebeb2ed714aa533abb9ce5456a167aac.png) Best regards! ---
**Author:** ![DStone1](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@DStone1](https://community.hubspot.com/u/DStone1)\ **Post date:** [January 10, 2023, 1:19pm UTC](https://community.hubspot.com/t/custom-report-builder/72529/5 "2023-01-10T13:19:12Z")
Thank you, again, for the quick response. Unfortunately this only affects the KPI graph (first picture), and does not affect the report details (second picture). Perhaps it’s not possible? But it seems a bit strange that you couldn’t do this. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 10, 2023, 1:22pm UTC](https://community.hubspot.com/t/custom-report-builder/72529/6 "2023-01-10T13:22:48Z")
Hi @DStone1, You can double check with support but in these cases, if the available settings don’t affect what you’re seeing, it’s likely not possible at this stage, unfortunately. Best regards!