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])
Nikita You can use distinct clause with AGGR function.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Please post sample application so that I can help you.
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
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.
