Good morning,
I am trying to return the [CAR Number] that is associated with the MAX of my custom measure DateDiff(Day, [CAR Create Date], NOWDATE) WHERE [CAR Close Date] = '1900/01/01'. I am only trying to return one row. So, it would look something like this:
Oldest CAR # of Days Open | Oldest CAR #
216 | 245
I can get my attribute to return the correct CAR Number, but it's pulling multiple rows, and I want my report to be only one row. How can I return the [CAR Number] associated with the MAX DateDiff formula listed above?
thank you,
