Dear All

I have created a crosstab with :



Grouped Rows Headings
Company
Product Name

Grouped Column Headings
Month of Sale

Sum Value

The query shows

Company Product Month a Month b Month c
ABS AA 12 34 56
ABS BA 16 35 46
CGG CA 5 8 86
GGS GC 18 9 5
GGS GD 19 4 96
MGS MA 17 8 16

My question is: how can i produce the sum of a Product over all the Months?


Company Product Month a Month b Month c Total
ABS AA 12 34 56 102
ABS BA 16 35 46 97
CGG CA 5 8 86 …
GGS GC 18 9 5 …
GGS GD 19 4 96 …
MGS MA 17 8 16 …

I managed over the report to generate the total of all Products for each month

Company Product Month a Month b Month c
ABS AA 12 34 56
ABS BA 16 35 46
CGG CA 5 8 86
GGS GC 18 9 5
GGS GD 19 4 96
MGS MA 17 8 16
Total 87 98 ...

But I can not prduce the Product/Months sum

I tried to place, in the “Detail” area of the linked report, the sum function and the addition function


=[08-1]+ [08-2]+ [08-3]+ [08-4]+ [08-5]+…
=Sum[08-1]+ Sum [08-2]+ Sum [08-3]+ Sum [08-4]+ Sum [08-5]+…


The problem is that it works only when every field has a value. If for example a Product was not been sold in January, but only in Feb and Mar,... the sum is not calculated.



If however a product has sold over every moth the sum is calculated!


Hope you guys can help me either over the query or with a function in the report and thx in advance for your help