Pivot Table - hide if no data

[Guest]

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

 

[Guest]

Why don't you link via MS Query and preset your criteria, or link to a query
in Access that has your required criteria. It sounds to me like you're
getting all the rows returned.

 

[Guest]

The underlying table in Access is used for a variety of people, who have
pivot tables linked to it. There are about 25 possible data fields, and the
multiple pivot tables only look at what they want.

Thanks anyways.