Avg of Top 10 values

[#1]

Hi all ,Gysbert Wassenaar

I am struck with a task. All I want is to show the  Avg of top 10 score values whose sentiment is positive in a text box.

In other words , I have Klout count  and sentiment . For sentiment 'Postive' , I need to calculate average KLOUT value of top 10 Klout counts.

Sample data is attached.

Any help would be appreciated.

Thanks in Advance

Best Regards,

Susvith

[Gysbert_Wassenaar · Accepted solution]

=avg({<screenname={"=rank(sum({<sentiment={'Positive'}>}klout_count))<11"}, sentiment={'Positive'}>}klout_count)

[#3]

Thank u so much Brother.

Thanks a ton man