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%

View Answer

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: