Straight table values in Text Objects

[noman212]

Hi Friends,

I have a dashboard which displays top 5 Annualized Premium on the basis of that we have related values against these annaulized Premium as shown below their Sum at Risk, Consultant Name and Branch name.

i have a requirement now. i want this top 5 values in Text Objects.

Like

If annualized premium of top 1 Client is 10,000 i want the Client name of against this Annualized Premium their Sum at risk and their Branch and Consultant name, all these 6 Column values mentioned below i want in seperate text object for top 5 Clients whose paid the highest Annaualized Premium..

How can i achieved this please help..

Client Name	Proposal	Annualized Premium	Sum at Risk	ConsultantName	BranchName
Lashma Raam	671815/KP-150	10,000	395,600	Raza Hassan	Ahmed Pur East
Muhammad Aslam	671813/KP-735	8,192	160,000	Muhammad Arif Nadeem	Gojra*
Muhammad Khan	671819/KP-732	8,000	80,000	Haq Nawaz	Chakwal*
Liaqat Ali	671834/AH-602	1,407	841,655	Nasir Ali Bhatti	Moro
Saeed Sarwar	671836/AH-602	1,237	346,000	Nasir Ali Bhatti	Moro

Regards

Noman khan

[MK_QSL · Accepted solution]

Use below in text boxes.

= 'Rank 1 : '& CHR(10) &

'Client Name - '& FirstSortedValue([Client Name], -Aggr(SUM([Annualized Premium]),[Client Name])) & CHR(10) &

'Proposal - '& FirstSortedValue(Proposal, -Aggr(SUM([Annualized Premium]),[Client Name])) & CHR(10) &

'Annual Premium - '& FirstSortedValue(Aggr(SUM([Annualized Premium]),[Client Name]), -Aggr(SUM([Annualized Premium]),[Client Name])) & CHR(10) &

'Risk - '& FirstSortedValue(Aggr(SUM(Risk),[Client Name]), -Aggr(SUM([Annualized Premium]),[Client Name])) & CHR(10) &

'Consultant Name - '& FirstSortedValue(ConsultantName, -Aggr(SUM([Annualized Premium]),[Client Name])) & CHR(10) &

'Branch Name - '& FirstSortedValue(BranchName, -Aggr(SUM([Annualized Premium]),[Client Name]))

= 'Rank 2 : '& CHR(10) &

'Client Name - '& FirstSortedValue([Client Name], -Aggr(SUM([Annualized Premium]),[Client Name]),2) & CHR(10) &

'Proposal - '& FirstSortedValue(Proposal, -Aggr(SUM([Annualized Premium]),[Client Name]),2) & CHR(10) &

'Annual Premium - '& FirstSortedValue(Aggr(SUM([Annualized Premium]),[Client Name]), -Aggr(SUM([Annualized Premium]),[Client Name]),2) & CHR(10) &

'Risk - '& FirstSortedValue(Aggr(SUM(Risk),[Client Name]), -Aggr(SUM([Annualized Premium]),[Client Name]),2) & CHR(10) &

'Consultant Name - '& FirstSortedValue(ConsultantName, -Aggr(SUM([Annualized Premium]),[Client Name]),2) & CHR(10) &

'Branch Name - '& FirstSortedValue(BranchName, -Aggr(SUM([Annualized Premium]),[Client Name]),2)

Replace 2 with 3, 4, 5 etc for Rank 3, Rank 4 and Rank 5

[noman212]

Thanks alot MRKachhiaIMP