Hi, I'm looking to sort data on this chart by lease break date. Each building has up to 5 lease breaks so I'm thinking I need some sort of IF statement to get the sort to look at the earliest date from today but across all the buildings.
The Dimension is "Location"
The Expressions are Lease Break 1 - 5 and Lease Expiration (blue dots below)
As always ideas and help appreciated.