PivotdrillHow many orders per product
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 how many orders there are for each Product.
What this exercise teaches
Count counts records that are not blank. Counting the same field you group by is a common way to get order counts.
A hint if you get stuck
You are counting rows, not adding a number. Any field works with Count; a text field is counted automatically.
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