1 Reply Latest reply on Oct 4, 2013 9:20 AM by Matt Lutton

    Show last trade date

    Jeff Stanley

      I have a table which shows the quarterly sales totals for 3 customers. I have added a MAX(trade date) function to find the last trade date, but this then displays the last date for each quarter.

      Capture.JPG.jpg

       

      How can I only display the actual last trade date from the most recent quarter, ignoring those before? Essentially like this, which I created by hiding the offending data:Capture2.JPG.jpg