--- title: "Group report: step by step example" description: A group report simplifies the complexity of your data by allowing you to combine data you collected from multiple responses into one report. Discover it now👉 --- [Skip to content](https://help.pointerpro.com/group-report-step-by-step-example#main-content) [![Pointerpro-logo](https://help.pointerpro.com/hs-fs/hubfs/Pointerpro-logo.png?width=188&height=53&name=Pointerpro-logo.png)](https://pointerpro.com/) - [Getting started](https://help.pointerpro.com/how-to-get-started-with-pointerpro) - [Pricing](https://pointerpro.com/pricing) - [Customer stories](https://pointerpro.com/case-studies) Open main navigation Close main navigation - [Getting started](https://help.pointerpro.com/how-to-get-started-with-pointerpro) - [Pricing](https://pointerpro.com/pricing) - [Customer stories](https://pointerpro.com/case-studies) - [New here? Explore what Pointerpro can do](https://www.pointerpro.com/) [New here? Explore what Pointerpro can do](https://www.pointerpro.com/) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.pointerpro.com/?hsLang=en) 2. [Report Builder](https://help.pointerpro.com/report-builder?hsLang=en) 3. [Aggregate Reports](https://help.pointerpro.com/report-builder?hsLang=en#aggregate-reports) # Group report: step by step example ## A group report simplifies the complexity of your data by allowing you to combine information you collected from multiple responses of your assessment, into a single comprehensive report. This not only saves time but also provides a holistic view of trends and patterns across different respondents.  ##### You'll need this: - One of these Pointerpro plans: ![](https://assets.pointerpro.com/custom/help-guide/Pointerpro+icon+Grey.svg)  Professional         ![](https://assets.pointerpro.com/custom/help-guide/Pointerpro+icon+Grey.svg)  Enterprise         ![](https://assets.pointerpro.com/custom/help-guide/Pointerpro+icon+Orange.svg)  ReportR         ![](https://assets.pointerpro.com/custom/help-guide/Pointerpro+icon+Orange.svg)  DistributR  --- WARNING   Aggregate reports are an extra feature with an additional fee. Don't hesitate to get in touch with [sales@pointerpro.com](mailto:sales@pointerpro.com) for additional information. WARNING   It is important to note that in the group report, you can only use aggregated data (such as the average of a formula) and static data (such as the question text). You can find them in the variable selector. **Variables that are related to individual responses can not be used in the group reports **(for example: the answer on a question of 1 person in your group).  This guide will illustrate the process of creating a group report by using an Employee Happiness assessment as an example. Respondents have the option to choose their company and department before answering the questions. The resulting report provides insights into the overall happiness of employees within the chosen company, both collectively and categorized by department. ##### On this help guide page: 1. [Add questions](https://help.pointerpro.com/group-report-step-by-step-example#add-questions) 2. [Add custom score](https://help.pointerpro.com/group-report-step-by-step-example#add-custom-score) 3. [Create formulas with filters](https://help.pointerpro.com/group-report-step-by-step-example#create-formulas) 4. [Create the Group PDF report](https://help.pointerpro.com/group-report-step-by-step-example#create-group) 5. [Add predefined filters](https://help.pointerpro.com/group-report-step-by-step-example#pre-defined) 6. [Download the group report ](https://help.pointerpro.com/group-report-step-by-step-example#download-the-report) --- #### 1. Add questions 1.1 [Create the Questionnaire](https://help.pointerpro.com/group-report-step-by-step-example#create-questionnaire) 1.2 [Add your questions](https://help.pointerpro.com/group-report-step-by-step-example#add-your-questions) ### 1.1 Create the Questionnaire At the Questionnaires tab, click **Create Questionnaire**. ![How to create a group report- create questionnaire](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214269034/original/lfBIR7i0bMdT4wa8Mn61ukBHxNRL8Rwo7g.png?1698394612) Click Start from scratch so you can add your own questions and style.![How to create a group report- start from scratch](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214269051/original/p3jcM1AdMU50sAZUmCqYhpI5U-tUrv3drw.png?1698394631) ### 1.2 Add your questions To add your questions just click the "?" Question button to insert your first question. ![How to create a group report- add questions](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214269937/original/UC476MWWKTKKy3qnFdhNCZnASMStU5bqHw.png?1698395261) You'll be shown [different question types](https://help.pointerpro.com/migration/knowledge/overview-of-different-question-types?hsLang=en) you can choose from. Choose your desired question type and click Add. ![How to create a group report- add questions](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214269995/original/N9VyL8OKKVB1f51yF-GMTcgxNpzCJVK_hQ.png?1698395305) For this example, we are going to use the [Text choice](https://help.pointerpro.com/migration/knowledge/text-choice?hsLang=en) and [Slider numbers](https://help.pointerpro.com/migration/knowledge/number-slider?hsLang=en) question types. The first two questions are about the Company and the department of the respondent.![How to create a group report- company question](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214270628/original/RDlrdPYi1d5SDMaNvgjdbFNh4wX2k0sJ1Q.png?1698395669) ![How to create a group report- department question](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214270732/original/qsMrgXFR25nwkJhIO645xTCtXvYi4RpdoQ.png?1698395732) The remaining questions are about employee happiness. ![How to create a group report- remaining questions](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214270918/original/fvsk5qxaeSVw9g_LWBv2rqApUmyWsudFWw.png?1698395868) #### 2. Add custom score To enable [custom scoring](https://help.pointerpro.com/migration/knowledge/custom-score?hsLang=en), go to the Extra Options tab and toggle the button.![How to create a group report- add custom score](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214271570/original/qwMvojwc1w2D2FK_c0SX5uCzeh2vv5qEJQ.png?1698396230) Now go back to your questions, and add a score next to each answer option.![How to create a group report- custom score](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214271716/original/0JMb07VsV0Izx-3gM_bUDjJ7gkwoBnRglA.png?1698396316) ![How to create a group report- custom score](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214271774/original/RMr4gI6M0MlnEwlgdeDep4slzGYQZm68aw.png?1698396346) Note that the custom score for the [slider number](https://help.pointerpro.com/migration/knowledge/number-slider?hsLang=en) question type is calculated automatically (1-10). All you need to do is to enable the custom score for this question.![How to create a group report- custom score](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214271817/original/IH4trChCFrTMaU_tbEUXYrCehKO4F3HhwA.png?1698396373)![How to create a group report- custom score](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214271951/original/ZaFjqw2u3DA8jETYFo2fCRMqMoTUvGbp1g.png?1698396468) #### 3. Create formulas with filters 3.1 [Formulas Introduction](https://help.pointerpro.com/group-report-step-by-step-example#formulas-introduction) 3.2 [Create formulas and add filters](https://help.pointerpro.com/group-report-step-by-step-example#add-filters) ### 3.1 Formulas Introduction This step is critical. Your [formulas ](https://help.pointerpro.com/migration/knowledge/formulas?hsLang=en)and filters enable the creation of a group report and facilitate score calculations. Within the formulas editor, you can add variables and create mathematical calculations.![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35265239327/original/yIElZeoWWHg8vN1aqg1xuBF7BLeYxbk7_w.png?1744201207) The toggle buttons provide additional options to refine your formulas. More specifically: - Use Rounded Numbers: This toggle allows you to round the results to whole numbers for a cleaner presentation. - Include Multiple Responses in Formula Calculation: Enabling this toggle allows you to aggregate data, create group reports, and calculate averages based on multiple responses. This one should be enabled. - Recalculate Formula on Report Generation: When the report is requested, this setting triggers a recalculation of the formula in the backend. This ensures that responses meeting the filter criteria are accurately accounted for, providing access to the most recent data. This feature is useful when using a formula with a variable that can change over time such as response count. Note that this feature is available on request. - Apply Filter Set When Downloading the Report: This ensures this formulas aggregation is only applied to the group you set when you download the report. This one should be enabled. ### 3.2 Create formulas and add filters To create your formula, click on the Extra Options tab and select Formulas in the Custom Scoring section. ![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214279780/original/l5ceg8SoiAfDJHjhx7WGPVRT4ot7QZ95sA.png?1698401417) Click on the Create Formula button and insert all the data. In this scenario, we require a total of 30 formulas.  Considering we have 5 departments and 4 questions, we need to create one formula for each question within each department. Additionally, 4 formulas are necessary to calculate the total scores for each question across the entire company. Furthermore, 6 formulas are needed to determine the total scores for each department and the overall company. Let's see how you can set up the formulas for the first question and the total scores. In the first formula, our aim is to create the company's score for question 3, focusing on Work-life balance. We utilize the variable \*|q3\_custom\_score|\* because we want to use the custom score from question 3. To standardize the score to 100, considering the question's maximum possible score of 4, we multiply it by 25.  We enable the toggle buttons as shown in the image below. There is no need for a filter, as we will filter later on per company.![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214280187/original/0VG2p9amU4_40cPULNaOypGOlcQqM4bp0Q.png?1698401678) Formulas 2 to 6 use the same value as formula 1 in the formulas editor, \*|q3\_custom\_score|\*\*25. However, this time, our focus is on department-specific filtering, so we implement a custom filter.![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214280795/original/nrM1l_zZAcK0nEjP_MWPeg_vJBKGECpS3g.png?1698402191)![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214280947/original/RRCShrq6LXCkOagsFhnCIOVQAZZzUkwefA.png?1698402311)![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214280968/original/aJBddNQJjWKSbxJmBItP160-wE1oVDScWA.png?1698402333)![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281026/original/AJk57YjB_0T_xQ5c8yJKWtHkZZhhQNENHg.png?1698402351)![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281055/original/NcXtE4SxlNH07CjlEh1gvKZB3l07eAjV0Q.png?1698402367)You can create the formulas for the rest of the questions in a similar way. Remember to adjust the multiplier if your maximum score varies from 4. For instance, if question 5 involves a slider question with a maximum custom score of 10, the formula value for that question should be \*|q5\_custom\_score|\*\*10. To generate total scores for specific departments and the entire company, sum up the scores for each question. Then, standardize the total by applying a multiplier to achieve a score of 100. It's important to note that you don't need to add a filter to the formula for the overall company score.![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281479/original/3aNJ-JTiHII4yiwmlCpsgXAe9qzURI3CRw.png?1698402734) You should create formula filters for the total score of each department.  ![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281568/original/BG0dnDPNRjNq3GIhzrq7xocOEuuCegVhFw.png?1698402821) ![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281619/original/bj4dBOLBroFbHvfCHMGKJ10-FY8rlX_u7w.png?1698402872) ![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281650/original/Agwkypy-bz5q0FCFZMS9QevgIcQnlFjH5Q.png?1698402899) ![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281656/original/a08VA1MB0jYi24johkufl0hGy2B8WPr_0w.png?1698402918) ![How to create a group report- formulas](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214281674/original/q5NPuL0s-6yXSbaH-wc4eqdskAx8hVmqSQ.png?1698402942) Upon completing your assessment setup, be sure to save your progress! #### 4. Create the Group PDF report While your assessment editor is still active, you can click on the Report Button and then select +Create a new report. ![How to create a group report- create pdf](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214284476/original/13ept9NKjQCYNtnAcEajrQZQNX4aXxNwtA.png?1698405003) A new modal will appear, asking you to choose a template. In this instance, select the Empty template and click Next. ![How to create a group report- select a pdf template](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214284593/original/6GW4piNkIcEdQQPVSIL6hJvpAokb_FIppQ.png?1698405089) In the new modal, select the Group report type and click Next. ![How to create a group report- select report type](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35215209429/original/KxxuaREaoBCMwSTFNR3-r7bKGvgwN7SzSw.png?1699368195) The report editor will open, and you can start adding your [widgets](https://help.pointerpro.com/migration/knowledge/survey-widgets?hsLang=en). Creating a group report follows a similar process as an [individual](https://help.pointerpro.com/migration/knowledge/create-your-first-pdf-with-renewed-report-builder?hsLang=en) report. However, when generating charts and incorporating variables, you'll notice a reduced list of options, displaying only variables applicable to the group report. Feel free to utilize the formula variables you've set up for your assessment in the charts. ![How to create a group report- chart example](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214285571/original/dn1zLfFdxHBWmWhXbP0jJ9fTXsj9TC7xiA.png?1698405786) The above chart uses the variables \*|f1\_avg\_result|\* - \*|f6\_avg\_result|\* as we want to present the results of the work-life balance question. You can create a chart (or more) for each question using the rest of the formulas.  #### 5. Add predefined filters After you've finished creating your PDF and included all your content, save your work and navigate to the Share tab.![How to create a group report- predefined filters](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214286069/original/p8urjW42eLLaXjJA1gCJqmg2JY8HxK-1Ew.png?1698406127) Select the Predefined Filters tab, and click on the +Create filter to create your filter. You can create as many filters as you wish.![How to create a group report- predefined filters](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214286527/original/YIR1kFb5A9RO5csCUcN5oiP0XeGdbbYgkQ.png?1698406397) This step is optional and depends on your setup. You can either create predefined filters in the PDF editor or create them later on when you want to generate the group report. #### 6. Download the group report After collecting your responses, you can download the group report. TIP   Given the complexity of this setup, it's advisable to conduct thorough testing before deploying your assessment. You have the option to clear all responses prior to distributing the assessment to your contacts. To download the group report, go to the [results ](https://help.pointerpro.com/migration/knowledge/results-dashboard?hsLang=en)of your assessment and click on the Download button.![How to create a group report- results](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214287308/original/ap2vMnzuy2yXjoyThT3i_WKjlU8vg3Lq_Q.png?1698406897) In the new window, within the ReportR PDF (Group) tab, you can pick one of the predefined filters you crafted in the PDF editor. Select your choice from the dropdown menu.![How to create a group report- predefined filters](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214287943/original/PU-kzivpCov-aUqs4gG_6ud7cDu2gm2nvw.png?1698407238) Alternatively, you can select the Custom filter from the dropdown menu and add as many filters as you want by clicking the + button.![How to create a group report- custom filters](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35214288056/original/SulJ6LeA8I4Ovag5KFy77L2OYcE4k4RmZQ.png?1698407326)Once you've applied your filters (in this case, just one for the company), click on the Download button. In this example, we downloaded the group report specific to Company A, which provides a detailed breakdown by question and department. #### What's next? - An[ Individual vs Group report](https://help.pointerpro.com/migration/knowledge/how-to-create-an-individual-vs-group-report?hsLang=en) lets you compare how one person's answers compare to those of a group. This report type brings together the Individual and the group report types. This means that you can create a report to see at a glance how an individual's response stands against those of a specific group of your choice. - [Email invitations](https://help.pointerpro.com/migration/knowledge/email-invitations?hsLang=en) are messages sent to your saved contacts containing a link to your questionnaire and are fully customizable. It is the best way to inform your contacts about your new questionnaire, and at the same time, by using our analytics tools, to track who has opened and clicked on your message. - A [Contact list](https://help.pointerpro.com/migration/knowledge/contact-list?hsLang=en)includes the people to whom you will email a questionnaire invitation and it allows you to send your questionnaire to a lot of people simultaneously, using the same invitation. #### Don't want to build it yourself? Contact our professional services team[![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35228078736/original/HUqKSGp57WDc1aRvExWBQ2CBzb0RiQjAHQ.png?1711722247)](https://s.pointerpro.com/get-in-touch?lang=en_us) - [Getting Started](https://help.pointerpro.com/getting-started?hsLang=en#main-content) - [Getting Started](https://help.pointerpro.com/getting-started?hsLang=en#getting-started) - [How To Guides](https://help.pointerpro.com/getting-started?hsLang=en#how-to-guides) - [Glossary](https://help.pointerpro.com/getting-started?hsLang=en#glossary) - [Build & Design](https://help.pointerpro.com/build-design?hsLang=en#main-content) - [Intro Screen & Final Screen](https://help.pointerpro.com/build-design?hsLang=en#intro-screen-final-screen) - [Question Types](https://help.pointerpro.com/build-design?hsLang=en#question-types) - [Media & Variables](https://help.pointerpro.com/build-design?hsLang=en#media-variables) - [Design your survey](https://help.pointerpro.com/build-design?hsLang=en#design-your-survey) - [Campaigns](https://help.pointerpro.com/build-design?hsLang=en#campaigns) - [FAQ](https://help.pointerpro.com/build-design?hsLang=en#faq) - [Extra Options](https://help.pointerpro.com/extra-options?hsLang=en#main-content) - [Text options](https://help.pointerpro.com/extra-options?hsLang=en#text-options) - [Question logic](https://help.pointerpro.com/extra-options?hsLang=en#question-logic) - [Custom scoring](https://help.pointerpro.com/extra-options?hsLang=en#custom-scoring) - [Quiz Options](https://help.pointerpro.com/extra-options?hsLang=en#quiz-options) - [Kiosk mode options](https://help.pointerpro.com/extra-options?hsLang=en#kiosk-mode-options) - [Data collection options](https://help.pointerpro.com/extra-options?hsLang=en#data-collection-options) - [Other options](https://help.pointerpro.com/extra-options?hsLang=en#other-options) - [Integrations & API](https://help.pointerpro.com/extra-options?hsLang=en#integrations-api) - [FAQ](https://help.pointerpro.com/extra-options?hsLang=en#faq) - [Share & Results](https://help.pointerpro.com/share-results?hsLang=en#main-content) - [Sharing your questionnaire](https://help.pointerpro.com/share-results?hsLang=en#sharing-your-questionnaire) - [View Results](https://help.pointerpro.com/share-results?hsLang=en#view-results) - [Results Dashboard](https://help.pointerpro.com/share-results?hsLang=en#results-dashboard) - [Uploading and Downloading Results](https://help.pointerpro.com/share-results?hsLang=en#uploading-and-downloading-results) - [FAQ](https://help.pointerpro.com/share-results?hsLang=en#faq) - [Report Builder](https://help.pointerpro.com/report-builder?hsLang=en#main-content) - [General](https://help.pointerpro.com/report-builder?hsLang=en#general) - [Widgets](https://help.pointerpro.com/report-builder?hsLang=en#widgets) - [Aggregate Reports](https://help.pointerpro.com/report-builder?hsLang=en#aggregate-reports) - [FAQ](https://help.pointerpro.com/report-builder?hsLang=en#faq) - [Legacy Report Builder \[deprecated\]](https://help.pointerpro.com/report-builder?hsLang=en#legacy-report-builder-deprecated) - [Dashboard Builder](https://help.pointerpro.com/dashboard-builder?hsLang=en#main-content) - [General](https://help.pointerpro.com/dashboard-builder?hsLang=en#general) - [Widgets items](https://help.pointerpro.com/dashboard-builder?hsLang=en#widgets-items) - [Distribution Portal](https://help.pointerpro.com/distribution-portal?hsLang=en#main-content) - [Configuration](https://help.pointerpro.com/distribution-portal?hsLang=en#configuration) - [Management & Administration](https://help.pointerpro.com/management-administration?hsLang=en#main-content) - [Account & Billing](https://help.pointerpro.com/management-administration?hsLang=en#account-billing) - [GDPR compliance](https://help.pointerpro.com/management-administration?hsLang=en#gdpr-compliance) - [FAQ](https://help.pointerpro.com/management-administration?hsLang=en#faq) [![Pointerpro-logo](https://help.pointerpro.com/hs-fs/hubfs/Pointerpro-logo.png?width=140&height=39&name=Pointerpro-logo.png "Pointerpro-logo")](http://pointerpro.com) Can't find what you're looking for? Contact us at [support@pointerpro.com](mailto:support@pointerpro.com) Copyright © 2026, Pointerpro