calculate per year

[#1]

Hello guys!

I actually need help with some calculating in my application

i have values like TOTAL, YEAR AND CARLABLE

how can i calc the total value of the carlable per year

thanks for helping

[Anonymous]

I guess you can use a simple pivot table chart with Year and Carlabel as dimensions and sum(Total) as expression

[santiago_respane]

Hi Diar,

i would go with Oscar's sugestion but if you want the calculation to be done in the loading script you should use something like this:

Table1:

load Col1, Col2,Col3

from ...somewhere...;

join(Table1)

load sum(Col3)

resident Table1

Group by Col1,Col2;

Hope this helps.

Regards,

[jolivares]

Sum(Total <Ar> Totalt)

[#5]

actually my question was little confusing, i want to calc the Totalt table value per year per carlabel, not only per year.

[#6]

actually my question was little confusing, i want to calc the Totalt table value per year per carlabel, not only per year.

[jolivares]

Sum(Total <Ar,Marke> Totalt),

Sum(Aggr(Sum(Totalt),Ar,Marke))