I have the following table:
LOAD * INLINE [
I would like to create a variable that returns the name of the 4th in the list when ranked.
It can't be done on load script.
Thanks for your help
Is Value itself rank or you want to create rank based on value?
=FirstSortedValue(Name, Value, 4)
Try something like this
In your example, there is no 4th rank. So I changed little bit.
Load * INLINE [Name, ValueA, 10B, 5C, 3D, 4E, 4F, 6G, 7];
= MaxString(Aggr(If(Rank(Sum(Value)) = 4,Name), Name))
I got it,
Rank(Sum(Value), 4, 1), [Name]) = 4, [Name]
using the option 4 in the rank function was key due to the values been the same.
4 = Lowest rank on first row, then incremented by one for each row.
Retrieving data ...