Pivot table show dates instead of sum in value

Hi

I have a list of addresses, which have different facilities in propoperty. Each of these facilities has an installation date. What i want to do is to have the list down the side and the facilities at teh top and the dates as the date. All i can get it to do is to add them up or to give me a zero. I want it to look like

Address

Address	Kitchen	bathroom	windows
1 nowhere street	2011	2009	1979

Is there a way of doing this. Please help as soon as possible as it is driving me mad

Hi,

Welcome to the Forum.

Please post a sample template of your workbook using "Go Advanced" option.