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|
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?