You are right. I've attached something that looks like the dataset that I have with a pivot table set up the way I am trying to use it.

File: pivot_table-report_filter.xlsx

Thanks for having a look!

Geoff.