# Help with a report comparing actuals against target

**URL:** <https://community.spicecrm.io/t/help-with-a-report-comparing-actuals-against-target/392>\
**Category:** KReporter\
**Created:** [November 24, 2018, 3:46pm UTC](https://community.spicecrm.io/t/help-with-a-report-comparing-actuals-against-target/392 "2018-11-24T15:46:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![FibreCRM\_Simon](https://avatars.discourse-cdn.com/v4/letter/f/f07891/32.png) [@FibreCRM\_Simon](https://community.spicecrm.io/u/FibreCRM_Simon)\
**Post date:** [November 24, 2018, 3:46pm UTC](https://community.spicecrm.io/t/help-with-a-report-comparing-actuals-against-target/392/1 "2018-11-24T15:46:10Z")

</div>

Example Scenario:  
20 Users each with a sales target (stored in users\_cstm.target\_c)  
5 Departments each with 4 users (stored in users.department)  
Each Account has a value (stored in accounts\_cstm.billed\_c)  
Each User is Assigned To Accounts

Required Report: Monitor the performance of each department. Billed Amount against Target

We have tried the following  
Primary Module: Accounts  
Group by Accounts\>Assigned to user\>Department  
Sum Accounts\>Assigned to user\> Target  
Sum Accounts\>Billed

Cant seem to get it to work.  
Target summation does add up correctly.

We’ve tried setting Primary module to Users but there is no link to Accounts from there.

Is this possible?

---

<div class="post-metadata">

**Author:** ![FibreCRM\_Simon](https://avatars.discourse-cdn.com/v4/letter/f/f07891/32.png) [@FibreCRM\_Simon](https://community.spicecrm.io/u/FibreCRM_Simon)\
**Post date:** [November 27, 2018, 3:44pm UTC](https://community.spicecrm.io/t/help-with-a-report-comparing-actuals-against-target/392/2 "2018-11-27T15:44:34Z")

</div>

We have found a workaround using a union.
