Rank, aggr?

[#1]

I have one table there are the person_IDs and timestamps stored. I have created a new table there I give for every single person_ID a random number.

For my result I want to have an pivottable with the 3 person_IDs that has highest random number and for evey person_ID only 5 highest timestamps.

I attach the excel-file with example-data to illustrate it.

I hope someone could help me...

Liivi

[johnw · Accepted solution]

Two calculated dimensions.

=aggr(if(rank(Random)   <=3,Person_ID),Person_ID)
=aggr(if(rank(Timestamp)<=5,Timestamp),Person_ID,Timestamp)

See attached.

[#3]

Thanx a lot!! It worked fine 🙂

Liivi