Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks alot MRKachhiaIMP