Next Up Summary #
I want to write a summary number that notes the "Next Up" City in my data.
X axis are city names (chronological sorted on Closing Date), Y Axis are values. Some of those cities are Closed, some are Ongoing - I can't use the series to break that status out visually by color, because I'm using a dual Y axis to show two sets of metrics values.
Can someone help me write a summary number that prints the name of the City who has the next upcoming "Closing Date"?
If I have the cities below in my data:
Denver January 20
Atlanta February 5
Boston February 10
Cincinnati May 1
I want the summary number to say: "Next Market: Atlanta"
The logic is the City with the minimum Closing date in the future.