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

Author Topic: Sort Rave Visualisation by More Than One Category  (Read 4465 times)

Offline GoKartMozart

  • Full Member
  • ***
  • Join Date: Oct 2017
  • Posts: 8
  • Forum Citizenship: +0/-0
Sort Rave Visualisation by More Than One Category
« 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