Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I write the formula for finding top 2 value by using of first sorted value function.
num(firstsortedvalue(aggr(count(SESSIONID),HUB),-aggr(count(SESSIONID),HUB),2) ,'#,##0')
but i have to write formula for other values.please help me,
Thanks,
Try this
=Concat(If(aggr(Rank(count(SESSIONID)),HUB) > 3,aggr(count(SESSIONID),HUB)),',')
Do you mean you need all the counts?
Hi anbu,
thanks for your reply.
Actually i have formulas for top1,top2,top3 values i want to formula for remaining counts(like others option of dimention limit tab of chart property).
Thanks,
Replace 3 by number of values you want to display
=Concat(If(Rank(aggr(count(SESSIONID),HUB)) <= 3,aggr(count(SESSIONID),HUB)),',')
Hi Anbu,
When i am trying to use your formula it shows some error
My exact need is i want other than top3 values.
please help me,
Thanks,
Try this
=Concat(If(aggr(Rank(count(SESSIONID)),HUB) > 3,aggr(count(SESSIONID),HUB)),',')