Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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?
total tcv should take the max value
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))
its showing empty table/.... errror in expression asweell
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.