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.