To display a monthly sessions by country report in a pivot table, the fields in the areas on the pivot table fields bar would be:

To display a monthly sessions by country report in a pivot table, the fields in the areas on the pivot table fields bar would be

(A) Rows: Country, Columns: Month, Values: Sessions (average)

(B) Rows: Month, Columns: Country, Values: Sessions (sum)

(C) Rows: Country, Columns: Month, Values: Sessions (sum)

(D) Rows: Month, Columns: Country, Values: Sessions (average)

Explanation

The values listed top to bottom should be in the rows and the headings listed horizontally should be column headings, the values in your answer should be the sum.

Conclusion

This question is from the Quiz section of the second lesson “Analyzing Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.

Leave a Comment

Share via
Copy link
Powered by Social Snap