Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM

Post Author: Joe D365 |

Do you have a requirement to create a report to sum a calculated field in a report? Are you thinking that this can only be done through a custom SSRS report? Guess what, you can accomplish this using the out of box report wizard! Use the steps below to find the sum of revenue field in a report created using report wizard in Microsoft Dynamics CRM.

Step 1. Access the reports wizard in the reports section.

Revenue Field

Step 2. Start a new report and click next

Revenue Field

Step 3. Specify the name of the report and chose the record type.

Revenue Field

Step 4. Specify the report filter criteria or specify the view to base the report on.

Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM

Step 5. Add column grouping and columns to the report. For the field that you would like to Sum on, chose the summary type on the properties of the column.

Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM

 

Step 6. Chose the format of the report.

 

Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM

 

Step 7. Validate the report summary and complete the wizard.

Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM

 

Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM

Hope this comes in handy. If you need additional tips and tricks on report writing, please feel free to check our very informative blogs or our CRM Book. In addition, the PowerObjects Education department is always churning out new Dynamics CRM material via webinars and boot-camp classes.

Happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

3 comments on “Sum of Revenue Field in a Report Created Using Report Wizard in Dynamics CRM”

  1. I have 3 amount fields that I am reporting through report wizard in CRM 2015. Is it possible to add another column that totals the 3 fields? And then to do a grand total of this line level calculated field?

      1. Thanks. But my question relates to reports produced in the wizard. I know how to use a field calculated in a form. Can I "create" a calculated field directly in the report?

PowerObjects Recommends