No matching

[soniasweety]

Hi All

Anil Samineni

Jyothish KC

franky_h79

im calcualting the top5 customers by region wisse in one table

other table i have detailed info

but if i select region i can t see the matching numbers for top5

how to fix it?

and one more -   in  Production  top5 table is taking lower value

means i have ID column so for perticular account two id;s are there  in that lowest values is showing in top5 table.  how to show the max value only in this case?

[soniasweety]

‌total  tcv should take the max value

[sunny_talwar · Accepted solution]

Here, try this

=IF(Aggr(NODISTINCT Rank(SUM(Value),4),Account_Region,[Account_Name]) <= 5 and

Max(TOTAL <Account_Region, Account_Name> Aggr(IF(Aggr(NODISTINCT Rank(Sum(Value),4),Account_Region,[Account_Name])<=5, Sum({<SERVICE_TYPE={'Service',Hardware'}>}Value)),Account_Region,[Account_Name], Sales_Stage)) = Sum({<SERVICE_TYPE={'Service',Hardware'}>}Value),

Sum({<SERVICE_TYPE={'Service',Hardware'}>}Value))

[soniasweety]

its showing empty table/....  errror in expression asweell

[soniasweety]

i have downloaded the file not copy pasted..but in expression there is missing single quotes i made the chnges now expressions OK... chking in production give me some time.    thanks alot.