I am importing a large amount of data from Excel that contains Countries, Years, and Series (e.g. various World Bank World Development Indicators, for all countries in the world, for 1960-2011). I have formatted the imported data into the following columns: Country, Series, Year, Value, so each indicator is named in the series column.
How do I, for example, create a scatter-plot where the x and y axes are two of my series (both currently imported in the same column)? Do I need to reformat the data so each series is a different column?
You could do that. You could also create two calcs along the lines of:
if [Series]="Education" then [Value] end
And use these along with the dimension that defines each point (country?) on the level of detail