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

cross tab report

Started by sspk, 07 Jul 2008 09:22:56 AM

Previous topic - Next topic

sspk

Hello All,
I am doing a crosstab report(attached file).Now i wanted to add a query calculation(% Gross= total([DOLLARS1]/<#Total(Molecule)#> ie  the % of dollars for each qtr seperatly) beside QTY1,DOLLARS1 columns.But it is not allowing me to calculate like that. Is there any way to do that.This is really urgent any ideas will help me alot.
Thanks