If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Sort Rave Visualisation by More Than One Category

Started by GoKartMozart, 14 Nov 2017 04:53:28 AM

Previous topic - Next topic

GoKartMozart

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