COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: GoKartMozart on 14 Nov 2017 04:53:28 AM

Title: Sort Rave Visualisation by More Than One Category
Post by: GoKartMozart on 14 Nov 2017 04:53:28 AM
Hi,

Are there any methods to sort a rave visualisation by more than one category? I've found the method for a single select single category here: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/t_rpting_sort_data_vis.html

Example:

Column Chart (Stacked) with:

Size: Income
Categories: Provider - Category Range Filtered Data
Extra Categories: Return Year, Provider Code, Subject Code, (nesting order is Return Year, Provider, Provider Code, Subject Code)
Series: Source Of Income Description - Category Range Filtered Data
Extra Categories: Source of Income Code (Nesting Order is Source of Income Description, Source of Income Code)

I'm able to sort provider by Income descending but the sort order isn't preserved when applying additional filters on Subject Code or Source Of Income Code.

Is this something I can't achieve in an active report?

Cheers

James