My pivot table layout looks at only some of the fields in an underlying
Access table. I'd like see only the rows that have data in these fields.

Ex: I want to see customer, product, current year sales, gross profit. My
underlying data also includes prior year spending. I don't want to see a row
for a customer that has only prior year spending. That isn't in my layout &
I don't want the pivot table junked up with this data.

Any suggestions