How to display top rank field name in text & image

[#1]

I would like to ask is it got a ways to display to display the output in the text & image same as the output in the pivot table?

From the picture above the "Pax Summary Report" outcome is based on this expression : "if(aggr(rank(sum(sub_ttl)),name_storeno)<=10,name_storeno) "

From the expression above, it will result the highest revenue of all the store and display in the pivot table (pax summanry report) without choosing from the "Store Name" Fields.

Now the problem is i using the same expression in text & image (box below Year Field), it does not come out the result as i expected. Is it got any idea on the expression to display what am i expected?

Thanks

Regards

Yap.

[swuehl]

Try something like

=Concat(DISTINCT {<name_storeno = {"=Rank(Sum(sub_ttl))<=10"}>} name_storeno, ', ')

To display Top 10 stores in your text.