sum group

[celamar]

It forgives my English, I am brazileira...

As to add the values in groups?

Code:

Father 1 -------- 
      Son 1 -------- 
         Grandson 1 -------- 5,00
         Grandson 2 -------- 5,00
         Grandson 3 -------- 5,00

      Son 2 -------- 
         Grandson 1 -------- 1,00
         Grandson 2 -------- 1,00
         Grandson 3 -------- 1,00

 

I want to add the values above that it is in the following way:

 

Code:

[code]Father 1 -------- 18,00 Son 1 -------- 15,00 Grandson 1 -------- 5,00 Grandson 2 -------- 5,00 Grandson 3 -------- 5,00 Son 2 -------- 3,00 Grandson 1 -------- 1,00 Grandson 2 -------- 1,00 Grandson 3 -------- 1,00

 

sql are grouped by father and son and have only the value of the grandson

 

thanks

[dries863]

It is possible to create a Sum in the group footer -> create a new Variable(view->variables->new and use Sum as calculation type).

 

As fas as I know you can only use this sum variable in the group footer(but perhaps there is a way to get a sum in the header...).

[celamar]

With the son it gave certain.

With the father it does not add when null has value =null