how to show top 10 values in 10 text boxes....

[#1]

Area, count(area)

a,3

b,9

c,2

d,5

e,1

f,12

g,4

display like..

textbox1- f:12,

textbox2- b:9,

.

.

.

.

textbox10- j:40

[gautik92]

Count({$<Area=only(aggr(if(Rank(count(area))=1, Area), Area))>}valuefield)

[pokassov · Accepted solution]

Hi!

=only(if(Aggr(Rank(sum(area))=1,Area),Area))&'  '&sum({$<Area={'=Rank(sum(area))=1'}>} area)

=only(if(Aggr(Rank(sum(area))=2,Area),Area))&'  '&sum({$<Area={'=Rank(sum(area))=2'}>} area)

...

[#4]

hi its showing only area....like  f

but I want to display f:12

[sunilkumarqv]

rename where count(value) as value

and use below in textbox expression

=only(if(aggr(Rank(sum(value)),Area)=1,Area))&':'&only(if(aggr(Rank(sum(value)),Area)=1,value))

=only(if(aggr(Rank(sum(value)),Area)=2,Area))&':'&only(if(aggr(Rank(sum(value)),Area)=2,value))

[#6]

thank you so much guys........

finally I got result.........with using this expression...special thanks to harshita and gowtham for immediate response......

=only(aggr(if(Rank(count([IR Area]))=10, [IR Area]), [IR Area]))&':'&only(aggr(if(Rank(count([IR Area]))=10, Count([IR Area])) , [IR Area]))

[#7]

Thanks

[#8]

Hi,

You can mark the correct and helpful answers and close the link .

Thanks and regards

Harshitha

[#9]

Hi,

Its sure help full to others

tanq for suggestion....

Thanks and Regards,

Kumar

[#10]

hi,

in the above requirement I want to dip lay values on Jan month only...in this condition where the expression will be changed.........

Thanks,

Kumar.

[pokassov]

=only(if(Aggr(Rank(sum({$<Month={'Jan'}>}area))=1,Area),Area))&'  '&sum({$<Month={'Jan'},Area={'=Rank(sum(area))=1'}>} area)

=only(if(Aggr(Rank(sum({$<Month={'Jan'}>}area))=2,Area),Area))&'  '&sum({$<Month={'Jan'},Area={'=Rank(sum(area))=2'}>} area)