P

Let's imagine I have a list of countries and the number of people for each of them. I would like to create a matrix representing the bigger countries which contain 50% of the mondial population.

The "top N" and "top %" function won't do the trick. If I had to create this matrix manually I would just order the country list by the number of people, and add each line in the matrix until the total amount of people represent 50% of the mondial population.

I just can't find a way to do that with Reporting Services 2005. Does anyone has an idea ?

Thanks

Well, I don't know if that's posible with Reporting Services. I would use a cursor and a temporary table.