MENU
You have the dataset shown in the following exhibit.
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
Suggested Answer: A
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
40 comments · newest first
JU
Julieta
11 months ago
Not sure if a calculated column is necessary for this.
KA
Kaitlyn
11 months ago
Definitely going with option A, it’s the simplest.
MA
Marsha
12 months ago
Surprised there’s no option to just sort and limit directly!
QU
Quentin
12 months ago
I think RANKX is a better option for this.
MA
Malcom
1 year ago
Just add a Top N filter to show the top 10 cities!
HA
Hassie
1 year ago
Option D seems a bit complicated. I remember we discussed calculated columns, but returning 'Not in Top 10' feels unnecessary for this task.
KR
Kristal
1 year ago
I practiced a similar question where we had to filter top values, and I feel like option C could be the way to go with TOPN.
TE
Terrilyn
1 year ago
I'm not so sure about B, but I remember RANKX being useful for ranking values. Maybe it could work here?
IO
Iola
1 year ago
I think option A sounds right since we learned about using filters to limit data in visuals.
BE
Beata
1 year ago
The last choice with the calculated column that checks for the top 10 cities is interesting. That could be a clever way to handle this, but I'll need to think it through carefully.
CA
Carla
1 year ago
The TOPN function looks promising, but adding a calculated column seems like an extra step. I'll have to weigh the pros and cons of that option.
YO
Youlanda
1 year ago
Hmm, I'm a bit unsure about the RANKX function. I'll need to double-check the syntax and how it works before deciding if that's the best approach.
AI
Ailene
1 year ago
I think the Top N filter is the way to go here. It's a straightforward solution that should get the job done quickly.
JO
Jolanda
1 year ago
Hmm, this looks tricky. I'll need to make sure I configure the OSPF process correctly on both routers, and get the interface settings right. I better review the OSPF configuration steps carefully.
AN
Antione
1 year ago
Recalled AY 08-09 slabs and that 80C deductions reduce gross income.
BU
Buddy
1 year ago
Okay, let's see. Creating a custom search and selecting it in each section seems like a good approach, but I'm not sure if that's the most efficient way to do it. I'll have to think about the other options.
IN
India
1 year ago
Option A all the way, baby! Keep it simple, stupid. Why complicate things when you can just slap on a Top N filter and call it a day? I'm all about efficiency, not complexity.
ME
Merilyn
1 year ago
D) Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return 'Not in Top 10'. In the visual, replace Sales Profit with the calculated column.
FR
Freida
1 year ago
C) Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
DY
Dyan
1 year ago
Exactly! Why make things complicated when you can just use a Top N filter?
PR
Princess
1 year ago
B) Configure the Sales Profit measure to use the RANKX function.
ZA
Zachary
1 year ago
Option A is definitely the way to go. Keep it simple and efficient!
LY
Lynsey
1 year ago
A) Add a Top N filter to the visual.
DE
Denae
1 year ago
A) Add a Top N filter to the visual.
JE
Jerry
1 year ago
Option D is an interesting approach, but I'm not sure if it's necessary to create a calculated column just to display the top 10 cities. Seems a bit excessive.
KA
Kathrine
1 year ago
Option C with the TOPN function seems like a good way to get the top 10 cities. It gives us more control over the data, but it might be a bit more complex than option A.
EL
Elbert
1 year ago
User3: Option A might be simpler, but option C seems more effective.
LO
Lonna
1 year ago
User2: I agree, it gives us more control over the data.
NI
Nikita
1 year ago
User1: I think option C with the TOPN function is a good choice.
TR
Trina
2 years ago
Option B with the RANKX function sounds interesting, but I'm not sure if it's the best approach for this scenario. Might be overkill for just displaying the top 10 cities.
DA
Dalene
1 year ago
C) Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
AL
Albina
1 year ago
A) Add a Top N filter to the visual.
SA
Sabra
2 years ago
I think option A is the most straightforward way to get the top 10 cities. It's a simple filter that will do the job without any additional calculations.
HA
Harrison
1 year ago
User4: Option A it is then, let's go with that.
LE
Lea
1 year ago
User3: I agree, it's a simple and effective way to show only the top cities.
KE
Kenda
2 years ago
User2: Yeah, adding a Top N filter seems like the easiest solution.
KA
Kallie
2 years ago
User1: I think option A is the most straightforward way to get the top 10 cities.
JU
Jutta
2 years ago
I disagree, I think we should add a calculated column to the table that uses the TOPN function.
WI
Winfred
2 years ago
I agree with Ling, adding a Top N filter would be the best option.
LI
Ling
2 years ago
I think we should add a Top N filter to the visual.