Pivot Table
 

I have created a Pivot Table in Excel that gets it's information from a query
in Access. The information I am trying to display is our Sales Data by
Customer. I would like to be able to display just the Company Name and not
the Company ID. The problem I run into is when I hide the Company ID it will
group the Company Names if more than 1 company has the same name. Is there
any way around this?
Thanks in advance!
Deb

Pivot Table
 

The short answer is no. Pivot tables aggregate data based on a hierarchy. In
this case the aggregation is by Customer name so even though there are
multiple customer numbers there is only one name under which the aggregation
occures.

Sorry... I don't have any great solution for you.

"Deb" wrote:

I have created a Pivot Table in Excel that gets it's information from a query
in Access. The information I am trying to display is our Sales Data by
Customer. I would like to be able to display just the Company Name and not
the Company ID. The problem I run into is when I hide the Company ID it will
group the Company Names if more than 1 company has the same name. Is there
any way around this?
Thanks in advance!
Deb