Pivot Table - hide if no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
Back
Top