5 Replies Latest reply on Nov 1, 2012 9:25 AM by Alex Kerin

    How Do I Select the Latest Value by Country

    Shane Graham

      I'm not sure whether this is doable with calculations or filters or both, but working with the attached workbook, I would like to select the latest GINI value for each country.  The year of the latest GINI value will vary by country, because not all countries have values every year.

       

      I'd like to end up with a result set like below, so I can show a map with latest value for each country.

       

      CountryGINIYear
      Afghanistan27.822008
      Albania34.512008
      Angola58.642000
      Argentina44.492010
      Bangladesh27.62010
      .........

       

       

      p.s. This is the definition of GINI for the curious:  http://en.wikipedia.org/wiki/Gini_coefficient