Hello,
I need helping adding headers to pivot tables and filtering. Let me explain, we have a spreadsheet of all equipment that comes in for repair. Under this spreadsheet we have dates for when we received the equipment, when ship the equipment to the vendor when it comes back from the vendor and when it gets delivered back to the customer. we do not want to delete records of equipment being delivered back to customer, however, when trying to create a pivot table IT pulls all data, (this is because we have data that is already completed) but my goal is I would like for the pivot table to pull the data only from the records where we have not delivered the equipment back to the customer yet. am i explaining my self?. if the column has a delivery date to the customer, i don't want excel to consider that data. ONLY what has not been delivered to the customer. Also, i have headers on the columns and i would like for the headers to show up on the pivot table. can anyone help?>
thanks
Bookmarks