Pivotdrill

Level 4: Show values as Exercise 17 of 31 Free

Share of revenue

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 each Region's Revenue as a percentage of total revenue.

What this exercise teaches

% of Grand Total divides every cell by the overall total, so the column adds up to 100%.

A hint if you get stuck

Keep Sum, then change Show values as.

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 Show values as