Pivotdrill

Level 1: Basics Exercise 1 of 31 Free

Revenue by region

A pivot table exercise from Pivotdrill. Solve it with a pivot builder in your browser with Rows, Columns, Values and Filters, and it is checked the moment you submit.

The task

Build a pivot that shows total Revenue for each Region.

What this exercise teaches

Rows decide the groups, Values decide what is calculated for each group. A number field in Values is summed by default.

A hint if you get stuck

The thing you group by goes in Rows. The number you add up goes in Values.

Try it now, no account needed

This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.

Open this exercise

More exercises in Basics