9 Replies Latest reply on Dec 21, 2016 5:08 AM by Witold Lisicki

    using max of field as filter

    Ijaz Osman

      I have a DATE field in my table, and I want to be able to filter for records based on the max Date of that field.  Seems like it would be pretty simple to create a calculated field (NewField=max(Date), but when I create one, it makes it a measure that I can't put into the Filter box.  I tried create another Calc field ([Date]=[Max Date]), but I get "Cannot mix Aggregate and non aggregate arguments to function"