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

Calculations on Measures in Crosstabs

Started by melee, 18 Oct 2010 11:07:43 AM

Previous topic - Next topic

melee

Hi everyone,

I'm getting familiar with Report Studio, but had a quick question regarding crosstabs and calculations.

Basically, I have a cross tab with a relational DB setup as so:

[Total] [Subtotal 1] [Subtotal 2] [Subtotal 3] [Subtotal 4] [Subtotal 5]

Basically, I'd like to get a percentage of each Subtotal and display it next to the column. I can do this using Javascript, but I have a feeling there's an easier way. Any ideas?

I guess my question is, how do I setup the calculation to select the total of [Total] and divide by the content in the cell - I've seen a couple of different functions, but I'm really confused.

jive

HI ,
I have that kind of report in crosstab,
In rows I have geographical information, in column the month choose from a prompt, age group (minor,major) and age by 5 year spread. The fact it's an amount of money , to get the the percentage we have to used : money/tuple(parent(currentMember(age_sp_5));money)
As I understand it, it will used the current total for the intersection divide by to total for all the group.. I know I'm not so clear but it's work ;-) . Look for " % of base" its almost the same.

Bye