D
Dee
Ok.. let's try it this way. I have a pivot table That has the fields
Manufacturer (that is sorted descending by the field Total), Description (of
product), MFG #, Unit Price, Quantity Shipped, & Total.
I only want to see the products that have the same MFG #, but a different
Unit Price (so as to track all of the products for which we have been charged
a different unit price. Is there an easier way to do this than to Hide all
of the records individually that I don't want to see? There are like 22,348
records total (before grouping). Please tell me there is an easier way to do
this.
I imported the data into access and was able to find the same data much
quicker, but due to the fact that I had to group all of the data, not all
fields were visible and my co-worker would like to see all of the fields
(like he can when he double-clicks on the item in a pivot table). So, if
there is a way in excel to make this easier, it would help.
Manufacturer (that is sorted descending by the field Total), Description (of
product), MFG #, Unit Price, Quantity Shipped, & Total.
I only want to see the products that have the same MFG #, but a different
Unit Price (so as to track all of the products for which we have been charged
a different unit price. Is there an easier way to do this than to Hide all
of the records individually that I don't want to see? There are like 22,348
records total (before grouping). Please tell me there is an easier way to do
this.
I imported the data into access and was able to find the same data much
quicker, but due to the fact that I had to group all of the data, not all
fields were visible and my co-worker would like to see all of the fields
(like he can when he double-clicks on the item in a pivot table). So, if
there is a way in excel to make this easier, it would help.