last 10 ranks

[johny.cbi]

I want to display last 10 ranks in a report

thanks for the reply

[blom0344]

Order the respective fact in ascending/descending order (depending on your needs)

[johny.cbi]

i have 1,000 items, i only want to show the last 10, not just sort them

[blom0344]

Yes I understand, but depending on the sort order the ranking will get you the top 10 or the last 10. (10 lowest values)

[almeids]

Read between the lines, Johny... you need to rank and filter.

[rockytopmark]

If your data source is OLAP or DMR, you can use the BottomCount() function.  I am not sure if this function will work with relationally modeled metadata.

[Gopinath]

Order the Rank field in descending order.

Create a condition in Condition Explorer as Rownumber()<=10

Set the the Boxtype Property of the fields to None, if the condition is false