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

Subtotal formatting in a dimensional report

Started by snowy, 13 Apr 2012 05:15:49 AM

Previous topic - Next topic

snowy

Hello all,

I'm doing dimensional reports for the first time, and I have a formatting requirement which I could do in a relational report but haven't a clue on planet dimensional..

So, I have a crosstab which currently looks like this:










Month 1Month 2Month 3
Customer X100200100
Customer Y808080
Customer Z140130120
-----------------------
Salesman 1 Total320410300
Count Customers333
-----------------------

The "Count Customers" subtotal is calculated as: count( currentMeasure within detail [Customers] ), and it's giving the right value. BUT I'd like to format it as follows:










Month 1Month 2Month 3
Customer X100200100
Customer Y808080
Customer Z140130120
-----------------------
Salesman 1 Total (3 Customers)320410300
Count Customers333
-----------------------

The way I'd do it in a relational report is that I'd unlock the crosstab, drag the "Count Customers" data item onto the correct row, and change it to Text Source='Data Item Value'. However in a dimensional report this just returns the data item name ("Count Customers") , not the value (3).

Does anyone have any idea how to do this kind of thing? The requirement is fairly flexible so anything similar would do the job...

Thanks for pondering!