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