how to create the top scorer in a text box !!

[fashid]

Hi,

I have created a scorecard which has 6 different pivot charts overlapped on one another representing parameters.

The last column is MTD score which changes on branch selection.

I need to get the top scoring branch in a text box to be displayed each month.

The top score should be based on the average score of all the parameters.

eg if branch del has average mtd score of all the parameters as 10

and branch  mum has average mtd score of all the parameters as 6

then the top branch would be delhi.

How could i go about doing this.

I have attached  the sample qvw which i am working on

Regards,

Nadeem

Message was edited by: nadeem shaikh

[fashid]

All I can say is thanks a million.

The - thing did it .

One small question :

IF i did not put the minus sign it should have still given me some value , but it was showing null .

What could be the reason for that ...

Regards,

Nadeem

[Gysbert_Wassenaar]

If several branches have the same value, for example 0, then the firstsortedvalue won't return a result. It can only return one result. Several branches with the same value means there is not only one result.

[fashid]

Thanks a lot for the nice explanation ...