0 Replies Latest reply: Nov 21, 2012 12:41 PM by Rob Wright RSS

    Sorting by Multiple Lease Events

      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)


      Sort by Dates.png


      As always ideas and help appreciated.