Hi experts,
I have created a crosstab for sales analisys and I need a calculated value in each cell.
The scenario:
in the rows there are the items;
in the summarize field there are Sum (quantity) and Sum (Total Amount);
in columns there is DocDate grouped by months.
      
            06/08       _______07/08    __________ Total
Item1   Qty1                  Qty2                      (Qty1+Qty2)
            Tot1                  Tot2                      (Tot1+Tot2)
            (Tot1/Qty1)??     (Tot2/Qty2)??         ((Tot1+Tot2)/(Qty1+Qty2)) ???

Item2   Qty3                  Qty4                      (Qty3+Qty4)
            Tot3                  Tot4                      (Tot1+Tot2)
            (Tot3/Qty3)??     (Tot4/Qty4)??         ((Tot1+Tot2)/(Qty1+Qty2)) ???
_________________________________________________
Total    Qty1+Qty3          Qt2+Qt4                 ..................
           Tot1+Tot3           Tot2+Tot4              ................
           (Tot1+Tot3)/       (Tot2+Tot4)/
           (Qty1+Qty3)        (Qty2+Qty4)


The problem is: how can I calculate the value = Total/Quantity in each cell???
Please please help me