Split Straight table into 2 tables

[Fareeha123]

I have field country and measure as  column1 (0-15days), column 2(16-30Days) column 3(31-60Days). Requirement is to show ascending order first 15 countries in first table, next 15 countries in 2 table and remaining in the last table. I am trying ceiling and rank function but i am not able to achieve the result. Can someone guide ? depending on client filter the number of countries will vary. Requirement is to design by default 15 countries in 1st table and so on. 

Please find attached screenshot of table. 

[Anil_Babu_Samineni]

try like this having one field

AutoNumber(Country, IterNo()) as Country_Rank

and use this for your measures to show like

Sum({<Country_Rank = {'<15'}>} Sales)

Sum({<Country_Rank = {'>15<30'}>} Sales)

[marcus_sommer]

I think you need at least a two-step approach for such a scenario whereby the first one calculates the entire table and the second one filters the results against the rank. It might be go in this direction:

sum(aggr(sum(Expr), Country, Days)) *
sign(match(rank(sum(Expr)), 1,2,3,....))