Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi have Created a table report show Trader wise no of Orders as given below:
i want to get the top traderid who have maximum number of Orders and display that Traderid into Lable or want to use that Traderid in set Analysis.
Please Help.
Thanks in Advance
Hi,
try this one.
Ex: = Only({$<Traderid={"=Count(MsgKey) = vMaxcount"}>}Traderid)
set below syntex to vMaxcount variable
=max(aggr(Count(MsgKey),Traderid))
find the attached file
Try this =Only({$<Orders = {$(=Max(Orders))}>} TraderID)
the Orders field is actually a expression Count(MsgKey) and the MsgKey is combination of Mumber and Character
Hi,
Try this:
firstsortedvalue(TraderId,-Count(Msgkey))
if you are getting traderid for minimum count then remove the minus "-" sing from Count(Msgkey).
HTH
Sushil
That is not working, in table box i am getting nothing '-'
Please share the sample app
Please find attached file
Hi,
try this one.
Ex: = Only({$<Traderid={"=Count(MsgKey) = vMaxcount"}>}Traderid)
set below syntex to vMaxcount variable
=max(aggr(Count(MsgKey),Traderid))
find the attached file
Thanks.. Natarajan.. Its Working Fine...