Here is a sample

ID Day Date Country City Venue Capacity Sold Fee % Gross Net Note
1 Thurs 19/10/2016 Norway Oslo Oslo Concert Hall 1200
2 Fri 20/10/2016 Sweden Malmo Malmo Live 2300
3 Sat 21/10/2016 Sweden Stockholm Cirkus* 2200
4 Sun 22/10/2016 Germany Bonn Beethovenhalle 5000


5 Fri 29/10/2016 England Buxton Opera House 975
6 Sat 30/10/2016 England Salford The Lowry 2200



I have been playing with pivot tables and have managed to come up with some fairly useful ones. What I can't work out at the moment, is how to show the last date we visited a certain venue. I have been trying to filter this info but not much luck at the moment.

Thanks, Rob