In my data set, I'm trying to get the earliest stock price for each stock, based on the users' selections of both stocks and dates. This is so I can show a % movement, always starting with a base of 100% for each stock, regardless of the user's selection.
Below is a sample data set and how I'd like the output to look.
I've got as far as FirstVal = aggr(FirstSortedValue(Close,Date),Co)
(I'm not sure why this appears only on the second line!)
What I would like to understand is: How do I get the First Val on to every line, so that I can use it to calculate the stock price re-based to the user's date range?