how to calculate other values in text box

[Anonymous]

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,

[anbu1984]

Do you mean you need all the counts?

[Anonymous]

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,

[anbu1984]

Replace 3 by number of values you want to display

=Concat(If(Rank(aggr(count(SESSIONID),HUB)) <= 3,aggr(count(SESSIONID),HUB)),',')

[Anonymous]

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,

[anbu1984 · Accepted solution]

Try this

=Concat(If(aggr(Rank(count(SESSIONID)),HUB) > 3,aggr(count(SESSIONID),HUB)),',')