How to sort the Legend order of a Line Chart using "2013 Sales"?

[lookingforK]

Hi,

I am using Cognos Report Studio 8.4.1 to create a Line Chart that has multiple series.

For example, the dataset could be:

Year   Store A   Store B   Store C   Store D   Store E   Store F
2008   ...   ...   ...   ...   ...   ...
2009   ...   ...   ...   ...   ...   ...
2010   ...   ...   ...   ...   ...   ...
2011   ...   ...   ...   ...   ...   ...
2012   ...   ...   ...   ...   ...   ...
2013   1000   800   3000   5100   2000   2700

The values in the above table (including ...) are Sales.

I set the Line Chart (with Markers) as:
* Default measure (y-axis): Sales
* Category (x-axis): Year
* Series: Store

I find the Legend Order doesn't match the Line Order. So, I want to sort the Legend Order based on "2013 Sales".

I try to use Properties - Chart Node Member - Data - Sorting for the chart, but it can't work.

How to deal with this issue?

Thank you in advance.