To see overall totals in a pivot table, which area would you use?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the WGU MKTG 6040 D381 E-Commerce and Marketing Analytics Exam. Use flashcards and multiple choice questions with hints and explanations. Ensure your success on this crucial exam!

Multiple Choice

To see overall totals in a pivot table, which area would you use?

Explanation:
The main idea is that totals come from the measures you summarize. In a pivot table, the Values area is where you place numeric fields to be aggregated (sum, count, average, etc.). Those aggregations produce the totals you see for each row, each column, and the overall grand total. The rows and columns define how the data is grouped and laid out, while the filters restrict which data is included. If nothing is in the Values area, there’s nothing to total. So to view the overall totals, you put the numeric field in the Values area.

The main idea is that totals come from the measures you summarize. In a pivot table, the Values area is where you place numeric fields to be aggregated (sum, count, average, etc.). Those aggregations produce the totals you see for each row, each column, and the overall grand total. The rows and columns define how the data is grouped and laid out, while the filters restrict which data is included. If nothing is in the Values area, there’s nothing to total. So to view the overall totals, you put the numeric field in the Values area.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy