I have a chart that shows is supposed the earliest time a sale is made sliced by town and the division that made the sale. Everything works well if i don't filter by the division. the objective is to see the min time a sale was made by town and then have each division see the town and the time for the first sale, ONLY the first sale and not other sales.
however when i filter by division on the list box Southampton shows up for the second sale made for the day which i do not want. I want it to show only when it was the first else it has to be null. I have attached screenshots and a worksheet to look at. this is one thing that is stopping my progress on a project i am working.