Exam4Training

What percent of the total sales does this group contribute?

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%
B . 23.39%
C . 27.73%
D . 29.49%

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:

Latest TDS-C01 Dumps Valid Version with 151 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version