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
Quote from: scognos07 on 04 Jul 2008 06:23:12 PM
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
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