Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have straight table for Top 5 Dealers in which i have Problem in displaying the order of Sl.No for some selection it is showing 2 numbers like 3-4 or 5-6 instead of displaying one at a time in order . So pls Help me out in resolving this issue where exactly the problm may be. Pls see the Attached Screenshot. The Expreesion I am using is
IF(aggr(rank((count({<COMMON_MONTH={$(#vMaxMonth)},[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number])
/
SUM(Sales_Volume)) * 100),Dealer)<=5,
aggr(rank((count({<COMMON_MONTH={$(#vMaxMonth)},[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number])
/
SUM(Sales_Volume)) * 100),Dealer))
Thanks in Advance,
NikithaJain
Nikita You can use distinct clause with AGGR function.
hi vikas,
I tried but its not working.
Please post sample application so that I can help you.
Vikas
try using rowno() or else
SubField(SINo,'-') as SINo in script
thanku for the reply Sivaraj
I tried using rowno() but the values will not cme properly so i tried using the above expression with rank function involved.
To use Subfield 'sl.no' field does not exist in the script.So I am directly using the expression in the Straight table. Is der any other way,pls suggest.