Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

CRM Reports - Functions and Attributes

Posted on by 15

On the main CRM-Sales User Interface for the Opportunities table, there is the "Run Reports" list of developed reports available to the business users.

I created a new report with the Opportunities entity using the Report Wizard. I was able to add columns, filters, Group filters, Configure Sorting, and add Groupings by key fields.

However, I would like to add a "Count" function within the report to count the number of Organization levels setup within each Opportunity and report that number as a column in the report. Essentially I would like the count function to be in the filters, or setup as a separate placeholder in the report, to count the number or organization level records within each Opportunity.

In the Report Wizard there doesn't appear to be an option to include either one of those capabilities.

At this time the work around is to have my users download the report to EXCEL, the add the count function, and use a Pivot table to isolate the Organization level counts.

Is there a way to include a count function in the Report Wizard? Is there a way to add SQL code to calculate counts in a report?

TIA

Randy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans