How to have 'top' without rank

[lahdeb]

Hi all

I m wondering if there is a way to have top 10 of a data item without using "rank" function ?

for example I want to have the 10 recent shippement for each shipper (top 10 date of shippement)

Thank you

[hespora]

on dimensional, I believe the function topcount can be used for that. on relational, I don't see an alternative solution.

Why rule out using rank, though?

[Invisi]

Bar charts have a property for it, if you need it for that. Otherwise: what he(spora) said.

[lahdeb]

Hello ,

Thank you for your reply , I want to have the top 10 of reports which failed exactly 8 times during their last 8 execution , so I m using rank to have the last 8 execution by report :)

[venkat01]

sorting on descending order to the measure column and do running-count(measure col or any col that you want) then drag this into filter running-count<=10 should get 10.

Sent from my GT-N8000 using Tapatalk