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

Crosstab - show rank based on outer level

Started by bberryhill, 08 Sep 2015 03:00:13 PM

Previous topic - Next topic

bberryhill

Hi -
My report is based on a transformer cube.  I am trying to show the top N customers based on revenue along with several other measures.  The customers have specific projects.  I want to show the same measures for the customers projects.  The problem is I cannot get the customer level ranking to display after nesting the project level within the customer set.  The project detail is correct and summarized for each customer as expected. 
The Revenue Rank is based on the customer
rank ([Revenue] within set [TopCustomer] )
so it makes sense that the rank column is blank when the project level is added.  But, I would like to show the customer's rank in the Summary row. 
Is there a way to unlock / change the summary row to show this information?

Any suggestions are greatly appreciated.  The attached word document images might be more clear.

                                           Revenue Rank    Total Sales    Margin .....
Customer ABC
                      Project 1                                   xxxxx.xx       xx.xx
                      Project 2                                   xxxxx.xx       xx.xx
                      Summary     ?customer rank?     xxxxx.xx       xx.xx
Customer XYZ
                      Project 3                                   xxxxx.xx       xx.xx
                      Project 4                                   xxxxx.xx       xx.xx
                     Summary      ?customer rank?     xxxxx.xx       xx.xx