Help with a Line Chart

[#1]

Hey guys, it's my first post.

I need help with a line chart that I am doing.

I have the Dimension set to Fiscal Year - going from 2008, 2009, 2010, 20011, and 2012.

The expression is where I am having trouble.

My Data looks like this:

Supplier #	VRR 12M FY10	VRR 12M FY11	VRR 12M FY09	VRR 12M FY12	VRR 12M FY08
GS0892	98.38434007	98.05403427	95.881	92.01468371	99.51119119
GS0701	99.62759788	97.67007269	98.05403427	96.82591361	95.881
GS0749	96.47435595	99.60593775	99.62759788	95.6739586	96.48787213
GS0652	92.01468371	99.0790686	69.0047782	96.48787213	99.81146014
GS0179	99.60593775	95.6739586	99.99197998	98.29159784	82.59682982
GS1524	96.82591361	95.0605002	99.81146014	82.59682982	99.60593775

VRR is a % (out of 100) rating a Vender's (Supplier) Reliabilty.

Fiscal Year is a field in another chart

Supplier# is a keyfield throughout all of my data.

What I need to do is to make a Line Chart that plots the VRR from FY08 - FY12 But I do not know how to set up the Expression, Any help out there?

Do I need to set up a new field or a variable that tells the Line Chart from which VRR box to draw data from?

[#2]

Have you tried building a line chart with the dimensions fiscal year and supplier and an expression like sum(VRR)?

This would show VRR per supplier and year.

Hope that helps.

Matt