As always, @ankit is spot-on. “Defeating” that context and getting a value to display unchanged over multiple rows is harder than you might think. Here’s a thread you might find helpful where @Melissa and I provide two different approaches:
Measure that dynamically calculates first value of a time series
Hope this is helpful.
- Brian
P.S. I had to work late last night so wasn’t able to tackle your other problem, but will definitely work on it today.