5 Replies Latest reply: May 8, 2013 12:20 PM by Nikitha Jain RSS

    Regarding the Display of Serial No

      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