Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Need help creating a report.
I have opportunities and each opportunity can have 3 sales people.
the user want me to produce a report that displays how many opportunities each sales person is associated with.
I'm thinking an SSRS report, but not sure how to
So for example we have the following opportunities.
opp1 has Sales people: A, B,C
opp1 has Sales people: A, B
opp1 has Sales people: B,C
So they want to see:
Sales person A = 3, B=4, C=2
What you need is the function like COUNTIF() in Excel.
For instance, Excel: count(OPP of A)=COUNTIF(field1, "A").
In SQL，you can use count( case when ....)
COUNT(CASE WHEN sales people = 'A' THEN 1 END);
Thanks for the info, but I'm doing this is SSRS using fetchxml. Is there a way to do it there?
You may need to find the similar function in SSRS.
Business Applications communities