Trying to add a date format to product value field based on column label -task description

[leanne2011]

Hi

I attach my pivot table with the raw data in another tab. I need to be able to view the date due for the two task descriptions as per my pivot, however when there are more than 1 line of data for the row, it is trying to do a sub tot to the value, as its date it cannot cope with this #########'s are reported. Is there a solution for this as this layout would meet my needs perfectly if I could stop the pivot from gathering the data to one row - I am happy to have lots of rows so long as the dates pull through in the columns

thanks
leanne

LB test pivot data.xlsx