ExamGecko
Question list
Search
Search

Question 98 - TDS-C01 discussion

Report
Export

Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

A.
25.79%
Answers
A.
25.79%
B.
23.39%
Answers
B.
23.39%
C.
27.73%
Answers
C.
27.73%
D.
29.49%
Answers
D.
29.49%
Suggested answer: C

Explanation:

We need to use the concept of Groups for this question. Follow along:

1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)

4) Finally, we get the following view and our answer:

asked 23/09/2024
Josefa Vera Gago
39 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first