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.
--
Kevin Backmann


"SusanJane sjl" wrote:

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

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.


"Kevin B" wrote:

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.
--
Kevin Backmann


"SusanJane sjl" wrote:

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