Discuss Salesforce Plat-Admn-201 Exam Topic 8 Question 11

A sales rep typically has several open opportunities for each of their accounts. Which tool should a Platform Administrator suggest to the sales rep to obtain the total number of accounts associated with open opportunities in a report?

ABucket Column

BReport Filter

CUnique Count

DGroup Rows

Suggested Answer: C

When a report contains many rows where the same Account name appears multiple times (due to having several opportunities), a simple count of rows will not accurately represent the number of distinct accounts. To find the specific number of individual accounts, the Platform Administrator should use the Unique Count feature on the Account Name or Account ID column in the report builder. Selecting 'Show Unique Count' provides a total at the bottom of the report (and in summary groupings) that counts each unique value only once, regardless of how many times it appears in the list. Bucket Columns (Option A) group data into categories46. Report Filters (Option B) exclude records47. Grouping Rows (Option D) visually organizes the report by Account but does not inherently provide a single summary number for the count of distinct accounts in the way that Unique Count does.

Get Premium Plat-Admn-201 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

24 comments · newest first

Solange 2 days ago

D) Group Rows might work, but it’s not straightforward for this.

Marlon 8 days ago

B) Report Filter could help narrow down, but not for totals.

Launa 13 days ago

A) Bucket Column sounds useful too, but not for totals.

Sheron 18 days ago

I think C) Unique Count is the best choice. It gives the total accounts.

Sarah 23 days ago

B) Report Filter is useful, but Unique Count is more precise for totals.

Eun 28 days ago

I feel C) Unique Count is straightforward. Less room for error.

Rosamond 1 month ago

D) Group Rows might help, but it won't give the total count directly.

Laurel 1 month ago

A) Bucket Column seems confusing for this. Not sure it fits the question.

Dorothy 1 month ago

I agree, but B) Report Filter could also work. It helps narrow down the data.

Shalon 2 months ago

I think C) Unique Count is the best choice. It gives the total number of unique accounts.

Laurel 2 months ago

Totally agree with you, Kathrine! Unique Count makes sense!

Juliann 2 months ago

Wait, are we sure Unique Count gives the right total?

Glenna 2 months ago

Definitely B) Report Filter for clarity!

Mitsue 2 months ago

A) Bucket Column could work too, but not sure it's the best choice.

Kathrine 2 months ago

I think C) Unique Count is the way to go!

Colton 3 months ago

I didn’t even know Unique Count was a thing! Sounds interesting!

Bernardo 3 months ago

A) Bucket Column could also be useful, but not sure it’s the best choice.

Dolores 3 months ago

Wait, are we sure about that? What if Group Rows works better?

Daniel 3 months ago

Definitely agree with that! Unique Count makes sense.

Taryn 3 months ago

I think C) Unique Count is the way to go for that.

Ressie 4 months ago

I practiced a similar question, and I think Bucket Column is more for categorizing data rather than counting unique entries.

Chau 4 months ago

I feel like Report Filter could help narrow down the results, but it doesn't actually count the accounts, right?

Tanja 4 months ago

I'm not entirely sure, but I remember something about using Group Rows to summarize data in reports.

Veta 5 months ago

I think the Unique Count option might be the right choice since it focuses on counting distinct accounts.

Salesforce Plat-Admn-201 Exam - Topic 8 Question 11 Discussion