COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: stevenbl on 07 Mar 2013 01:19:12 PM

Title: Sorting Bar Chart
Post by: stevenbl on 07 Mar 2013 01:19:12 PM
This seems simple but I can't find anyway to do this.
I have a bar chart showing country population by city.  I would like show the biggest bar on the left and work my way down to the smallest bar.  This would require me to sort by the metric and I can't find a way to do that.  Has anyone been able to do this?
Title: Re: Sorting Bar Chart
Post by: RKMI on 07 Mar 2013 01:38:56 PM
Hi Steven,

Assuming that the countries are in catagories on the (x-axis) click on the chart node member in your case country then in the left window you will see sorting, click the ... and set you sorting by draging and droping to the Metric. If the metric is not being used in the display make sure you have it as part of the properties, so that it used in the query. I hope this makes sense.

Thanks,
RK