One of the easiest approach is using LOD instead of table calc.
Because LOD can be used as dimension, it's really easy o handle sorting.
But to make LOD work with filtering , need to change all the filters to "Context"
This is Metric specific and
Just sort with this field.
Because it's already aggregated to Metric level, you need to "min" or "max" to pick up one value.
Sum does not work.
Hope above helps.
SURVEY TB_SM_10.4.twbx 951.0 KB
Aha! I wasn't expecting you to answer this one SOOOO FAST. Thank you so much. I copied you on another question explaining I copied you here by mistake and I really need help with the other one! Haha...can't thank you enough! I hope the other has an easy solution too.
You are welcome, but I don't agree with "an easy solution " the time I need to provide the solution and "Difficulty" does not match.
We are providing the answer with volunteering our time, but when some one say "Oh it's easy", that's easy for the people who get the answer in 10 ins, but we have spend >10,000 hours to have that questions answered in 10 mins.
We are trying to keep this community as a place people get answer with good quality with good timely manner. But if you think I am doing all the answer with just in 5 mins or so really easily, that's not a case.