I want to display last 10 ranks in a report
thanks for the reply
Order the respective fact in ascending/descending order (depending on your needs)
i have 1,000 items, i only want to show the last 10, not just sort them
Yes I understand, but depending on the sort order the ranking will get you the top 10 or the last 10. (10 lowest values)
Read between the lines, Johny... you need to rank and filter.
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.
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