use the saw function in results column to display a value of the comparison rows
I have a combined analysis report that shows the max of 2 records for each company.
Both rows will show a date field and a created by field
I want to compare the two date fields for that company to get the max date and then show the created by person in both records. I have the function to get the max date showing properly.
Example
Company Name Comparison Date Created by Column to show the max date: max(saw_1 by saw_0)) Column to show the Created by person of the max date??
Company ABC 1/1/2015 User123 3/1/2016 ??
Company ABC 3/1/2016 User999 3/1/2016 ??
Not sure what saw function to use (if possible) to show User999 on both rows.