I’m trying the set a variable (which is a sum of a quantity colum) in the header of the subsummary.
but this is not working.
If I place the same field in the subsummary footer, everything works fine.
So you are trying to put the results of the group summation into the header? The calculations may not be completed at the header time?
I also presume that you get a null output?
check:
that the variable “sum_quantity” should appear in the variable list AFTER any references to the fields and other variables it may depend upon.
I will have a quick look at the concept of having a dummy group after the subcat group and summing the variable over that group so the result is available in the (higher level) subcat group.