filter over ranking

Hello,

I have this top 10 i’ve created using a rank based on an amount. So far everything is ok but i have to split this top 10 into 4 different tables based on currency. to be more precised, in the top then i have transactions for the 4 currencies and i need to have one block for all and 4 different for each currency but only for the transactions on top ten. If i try to filter the rank by currency it will bring me 10 rows, top 10 for that specific currency instead of, let say 2 transactions for example. Also, if i try to create a variable rank() is no use since it is will change if i apply a filter. Does somebody have any ideas how i can make this split using BO?

Thanks!


antimo (BOB member since 2017-03-01)