News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Report that displays t...

Customer experience | Sales, Customer Insights,...

Answered

Report that displays the sum multiple field values

(0) Share

Report

Report

Posted on by Bill Hanna

112

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: A, B

opp1 has Sales people: B,C

So they want to see:

Sales person A = 3, B=4, C=2

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

Wei Xiong on at

Like (0)

Report

RE: Report that displays the sum multiple field values

You may need to find the similar function in SSRS.
Bill Hanna 112 on at

Like (0)

Report

RE: Report that displays the sum multiple field values

Thanks for the info, but I'm doing this is SSRS using fetchxml. Is there a way to do it there?
Verified answer

Wei Xiong on at

Like (1)

Report

RE: Report that displays the sum multiple field values

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 ....)

Example:

COUNT(CASE WHEN sales people = 'A' THEN 1 END);

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,409 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans