Hi I have a pivot table that is not acting how I want it and I cannot fathom out the problem



It is a simple PT at the moment with 4 columns, see attached.

The main table has 13 Columns and several hundred rows and is a record of the places we have been to.

Some places we have been to only once and others up to 18 times over the years.

The pivot table is to show only the last time we visited a place but then I want another column to show the Next Time we are heading there.

From my attached sample table you can see that Malvern is just showing (blank) and that Guildford is on 2 lines showing the Next Date and (blank) below it. The Next Date entry is correctly in line with the Max Of Date (2015) (last time) but the (blank) is in line with an even earlier time we visited (2013).

Malvern was identical but is just showing (blank) on the one line because I have removed the Next Date from the main table. If I double click on the Malvern row, the (blank) disappears along with the border lines leaving just white space.

Over 810 of the other rows are perfect but I cannot get to the bottom of why these couple of places should be like this.

I have checked all entries for accuracy, where a place as more than one entry, I have actually copied the first entry to the following cells so there are no typos or extra spaces anywhere, that I can find anyway.

Any help on this would be appreciated.

Thanks Rob

Attached Files

PivotTest.xlsx (8.9 KB, 20 views)