Pivotdrill

Level 2: Sorting and filtering Exercise 7 of 31 Free

Best region first

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

Show total Revenue by Region, sorted so the region with the highest revenue is at the top.

What this exercise teaches

Sorting by value keeps working when the data changes, unlike moving rows by hand.

A hint if you get stuck

Use the sort setting: by value, largest to smallest.

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 Sorting and filtering