Hi,

I have a spreadsheet with the following fields: Cost(F), Cost Code(I) and Phone(J).

I have created a pivot which will show each cost code and the sum of all costs against this Cost Code. The Phone field has one of two values(Mobile or Landline). I wish to add this to the pivot table is some way that the Phone field is not displayed or that the appearance of the pivot table does not change but so that I can filter by either Mobile or Landline.

Is this possible and if so, how?

Cheers
Paul