Hello all,
how can I calculate a product of two key datas line by line? The default is column by column but in this case I get a incorrect result.
Here is an example what I mean:
Table 1:
Month.........Type...... Distance(km)......Weight(kg).........Distance * Weight
Jan.............Typ_1.............2..........................10...........................20
Jan.............Typ_2.............5..........................20.........................100
Jan.............Typ_3.............4..........................10...........................40
Sum............................................................................................160 <-- correct Sum
When I list the key datas only for month I get a different sum(see Table 2)
How can I get the information in Table 2 with the correct sum of Table 1 ?
Can you help me to fix the problem ?
Table 2:
Month.......Distance (km)....... Weight (kg).................. Distance * Weight
Jan...................11...........................40...............................440 <-- incorrect Sum