I have monthly country data that arrives at different times. I want to calculate and report on a map the annual perentage growth of each country, based on the latest available data. So in the attached example, I have data for Malaysia till January 2013, India till Feb and Japan till March 2013.
I have a calculated field for the Year on year growth, but I cant see how to get the latest growth number for each country on the map.
Your help much appreciated
Graeme, first your YOY calc is returning a NULL. You should probably fix that before moving on to WINDOW_MAX.