PivotdrillApproved spending only
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 Amount by Category, counting only claims whose Status is Approved.
What this exercise teaches
A report filter changes which records are counted without adding Status to the layout.
A hint if you get stuck
Add Status to Filters and untick everything except Approved.
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