Hi,
I have a similar issue, I want to create a formula that splits the data into deciles, or 10 equal groups of total rows but i also want it should divide the data in 10 groups or equal rows/people basis the city they belongs.
For example, there are 300 rows for City1, 200 for city2, 400 for City3 . . . .
I want to create deciles which divide the data for city1 in 10 groups of 30 each, City2 in 10 groups of 20 each and so on..... sorted in descending/ascending order.
Thanks alot !!
I have a similar issue, I want to create a formula that splits the data into deciles, or 10 equal groups of total rows but i also want it should divide the data in 10 groups or equal rows/people basis the city they belongs.
For example, there are 300 rows for City1, 200 for city2, 400 for City3 . . . .
I want to create deciles which divide the data for city1 in 10 groups of 30 each, City2 in 10 groups of 20 each and so on..... sorted in descending/ascending order.
Thanks alot !!
