Placing SUBTOTALS in Specific Columns in EXCEL output

[LeonelSanchezJr]

I need to place my SUBTOTALS in specific columns in my EXCEL output.

I can do this in the PDF output via the stylesheet, but I can't get it to work in my EXCEL output.


Thanks,

Leo ;-)

 

[focwizard]

Leo,


Are you trying to ONLY get subtotals for selected columns, or do you want the subtotals to appear in different columns than the field you're subtotalling? If the latter, then we need to see an example.

If the former, then you can specify WHICH columns to SUBTOTAL, by naming them AFTER the SUBTOTAL keyword, like:

ON sortfield SUBTOTAL fld1 fld2 fld4