Pivotdrill

Level 5: Several values, nested rows Exercise 21 of 31 Free

Units and revenue together

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 both total Units and total Revenue for each Product.

What this exercise teaches

Each field in Values becomes its own column.

A hint if you get stuck

Values can hold more than one field.

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 Several values, nested rows