Hi,
- I have ranked countries based on interest rates. To be ranked they must be above a certain level.
I also have by country weight. For an individual country this can be greater than 100%.
example.JPG
I want to create a new set of columns. Where countries are included on the condition that the total of the weights across countries is less than 100%. I want to look at countries in order of their rank. For example, in the first row, Switzerland and Germanly would be included as they are ranked 1 and 2 and their total weights is less than 100%. Japan would not be included, as including would bring the total weight of the 3 countries to more than 100%.
Bookmarks