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
|