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