crosstab report

[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 total(dollars)/[total( (dollars) for (division) and (qtr) )] or 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

[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 total(dollars)/[total( (dollars) for (division) and (qtr) )] or 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

Any Ideas please

[blom0344]

Did you set the rollup aggregation to calculated for the percentage calculation? This should assign a solve number higher than those of the other calculations.

See 'Multiple Calculations in Crosstabs and Charts'  in the Professional Authoring User Guide