series line chart from same field

[Aussie John]

Hi I have a DB with fields "year", "university", "world ranking"

multiple records with

uni1>2004>rank

uni1>2005>rank

etc

uni2>2004>rank

uni2>2005>rank

etc

I would like to chart the yearly change with a multi series line chart.

I'm struggling to work out how to do this. As you can see from the screen shot I have the universities ranked but they appear in separate charts and I would like both universities to appear together on the one chart.

I've attached a v12 file (sorry if you don't have it) to help understand the format.

thanks for any help

test.fmp12.zip

[Aussie John]

For info I solved this by creating a related year table and a series of calc fields to catch the data from the original table.