Body: <p>I would love to be able to make a report in Civi using stock reports, extended reports or reports pro that produces or can be modified to generage the following output:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Employer</th>
  <th># of Employees</th>
  <th># of Employees that Donated</th>
  <th>Participation Rate</th>
  <th># of Contributions</th>
  <th>Average Contribution</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple Corp</td>
  <td>100</td>
  <td>7</td>
  <td>7%</td>
  <td>9</td>
  <td>$45</td>
  </tr>
  <tr>
  <td>Orange Corp</td>
  <td>32</td>
  <td>7</td>
  <td>22%</td>
  <td>9</td>
  <td>$95</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>&quot;# of employees&quot; = Number of employees in system with that employer listed</p>
  <p>So far i have been able to get the following:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Employer</th>
  <th># of Contributions</th>
  <th>Average Contribution</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple Corp</td>
  <td>9</td>
  <td>$45</td>
  </tr>
  <tr>
  <td>Orange Corp</td>
  <td>9</td>
  <td>$95</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>but that's the end of my progress. I also notice that if I choose to filter by tag, it uses the contributors tag and not the employer's tag :-/ I am also open to two reports that I can export into excel to generate the report I want.</p>
  <p>Thanks all!</p>
  <p>Edit: Sorry the second table shows up in preview, but then breaks in actual post. Civi 5.40 D7</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-10-27T18:36:01.447Z
Comments.Text: I haven't used the new SearchKit yet, it may be one option. If this were Drupal I would presume I could build this via Views (if necessary using views_field_view to bring the data in to one table)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-10-27T20:12:35.393Z
Comments.Text: I will check out searchkit and see what I can do in views - thanks!
Comments.UserDisplayName: themak
Tags: <civireport><relationships><reports><custom-reports>
Title: Possible to build contribution report that groups contributions by employer and includes number of employees?
ThreadText: # Possible to build contribution report that groups contributions by employer and includes number of employees?
  
  (Asked by: username_0 on 2021-10-27)
  
  I would love to be able to make a report in Civi using stock reports, extended reports or reports pro that produces or can be modified to generage the following output:
  
  | Employer | # of Employees | # of Employees that Donated | Participation Rate | # of Contributions | Average Contribution |
  | --- | --- | --- | --- | --- | --- |
  | Apple Corp | 100 | 7 | 7% | 9 | $45 |
  | Orange Corp | 32 | 7 | 22% | 9 | $95 |
  
  "# of employees" = Number of employees in system with that employer listed
  
  So far i have been able to get the following:
  
  | Employer | # of Contributions | Average Contribution |
  | --- | --- | --- |
  | Apple Corp | 9 | $45 |
  | Orange Corp | 9 | $95 |
  
  but that's the end of my progress. I also notice that if I choose to filter by tag, it uses the contributors tag and not the employer's tag :-/ I am also open to two reports that I can export into excel to generate the report I want.
  
  Thanks all!
  
  Edit: Sorry the second table shows up in preview, but then breaks in actual post. Civi 5.40 D7
  
  **Tags:** civireport, relationships, reports, custom-reports
  
  > **Comments:**
  > **username_1**: I haven't used the new SearchKit yet, it may be one option. If this were Drupal I would presume I could build this via Views (if necessary using views_field_view to bring the data in to one table)  
  > **username_0**: I will check out searchkit and see what I can do in views - thanks!  
  
  ---
  
  ## 0 answers
  
  