Please refer to sheet 5.
In the attached file, I have a column for date titled AS_OF_DATE.
In the measures, there's an average and a standard deviation of the field "OPEN INV"
I would also like to create a field that displays the most recent OPEN INV by AS_OF_DATE.
How do I create a formula that would make this work? Thank you.
Retrieving data ...