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

How to perform calculations in Measure part of Cross tab report

Started by aryanhanda, 15 Jul 2007 11:13:30 AM

Previous topic - Next topic

aryanhanda

Hi,
I wanted to know how to perform calculations in the measure part of the cross tab report.I wanted to make  following calculation:-

(value displayed in a particular cell) *100/ (sum of total values displayed in all cell of that particular row )

I have even made different data items in te query to perform this calculation ,but its showing errors..

Can anyone please help me on this....

MDXpressor

What is your datasource? (Relational:  Oracle, SQL, ...; Dimensional:  Powercubes...)
What are your errors?
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

aryanhanda

Database is Oracle.Though its a crosstab report but I am getting some list report error..

MFGF

Hi,

What errors are you getting exactly.  It's almost impossible to suggest what may be wrong unless you tell us exactly what errors you are getting...

Regards,

MF.
Meep!