Ok

Here is a cut down version of my table.

In this example, I am trying to show with a PT the last date that we visited a particular place. Then if a new date is arranged, the Next Date column will be added to.

The Pivot Table is exactly how I want it except for the following.

It shows (blank) in the empty date field. I don't want this but cant work out how to stop it, I just want a "blank" cell.

Whenever I add a Next Date to the list then the PT shows two "Last Dates" for the venue. See Forum Malvern and G Live, Guildford.

It appears that the PT is displaying the Last Date with the Next Date and also the Last Date with the latest "Blank" Date.

Is there a way round this to display it as I want it, just a single line with the 2 dates side by side, the next one either empty or with the next date added.

Thanks,

Rob

Attached Files

PivotTest.xlsx (20.2 KB, 10 views)