Tableau Exam Desktop Certified Associate Topic 4 Question 38 Discussion

Actual exam question for Tableau's Desktop Certified Associate exam

Question #: 38
Topic #: 4

[All Desktop Certified Associate Questions]

Which of the following are valid calculations?

AMAX(SUM(Profit), (Sales))

BSUM([Profit]) * SUM([Quantity])

CSUM([Profit]) * 1000

DSUM([Profit]) * [Quantity]

Show Suggested Answer

Suggested Answer: B, C

You cannot mix the aggregated and non-aggregated calculations.

MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not.

SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not.

You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.

SUM([Profit]) * SUM([Quantity]) - Both are aggregated

by Ashley at Jul 09, 2025, 05:20 AM

Limited Time Offer

25%

Off

Get Premium Desktop Certified Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Alease

B and C are the winners here. Who needs all that complicated MAX and SUM nonsense? Keep it simple, stupid!

upvoted 0 times

...

Mignon

7 days ago

D is the way to go! Multiplying the sum of profits by the actual quantity is much more meaningful.

upvoted 0 times

Elli

2 days ago

I agree, D is definitely the most meaningful calculation.

upvoted 0 times

...

Shawna

20 days ago

I agree with Brittni, C) is valid because it's a straightforward calculation.

upvoted 0 times

...

Elly

20 days ago

A and C look good to me. I like the simplicity of C - just multiplying the sum of profits by a constant.

upvoted 0 times

Lawrence

1 days ago

A) MAX(SUM(Profit), (Sales))

upvoted 0 times

...

Brittni

22 days ago

I think C) is valid because you can multiply the sum of Profit by 1000.

upvoted 0 times

...

Jenelle

28 days ago

I disagree, I believe B) is valid because you can multiply the sum of Profit by the sum of Quantity.

upvoted 0 times

...

Sharan

29 days ago

I think A) is valid because you can find the maximum of the sum of Profit and Sales.

upvoted 0 times

...