first value or a measure for min value of dimension

[Dipak]

Hi all,

I have a straight table with following structure. the final column $(vAHTRankDivision) is a formula defined as variable during data load. I want is one more column where the this value repeats for all values in first column.

i.e 53.42% should be repeated for all ID 83 in column 1, 99.07% should be repeated for all values 345 in column 1, '-' for 384. This is basically value of $(vAHTRankDivision) for the lowest value of date in column AsOfWeek.

@sunny_talwar , @swuehl  - again many post where i saw your reply on similar posts, but majority of them are in qvw and i can't open them anymore on my system. qvf file is attached here.

[sunny_talwar · Accepted solution]

You can try this, but there might be an easy way to do this

FirstSortedValue(TOTAL <[Person(Person - who) : Employee_Number]> Aggr($(vAHTRankDivision), [Person(Person - who) : Employee_Number], AsofWeek), Aggr(AsofWeek, [Person(Person - who) : Employee_Number], AsofWeek))