On column3 Subtotal as ''

The above will give subtotal based on break-up field. Can I avoid showing the column3 value?

Column1 Column2 column3 column4 count
Test1 test2 test3 test4 1
.........................test4 1
test3.......................... 2

Can I avoid displaying value of break-up column in subtotal?
i.e., test3 should not be displayed as below

Column1 Column2 column3 column4 count
Test1 test2 test3 test4 1
.........................test4 1
..................................2
............... ..test4 ............

ON COLUMN3 SUBFOOT
" <ST.COLUMN3 "

This will work but positioning will then be an issue. If this is PDF you can use spot markers or POSITION in the stylesheet for HTML.

You could also add a WHERE TOTAL that is always true. Ex:

SUM
COMPUTE DUMMY/I1 = 1; NOPRINT

...

ON COL3 SUBTOTAL ... WHERE TOTAL DUMMY GE 1;

By default, the field value is omitted when you have a WHERE TOTAL... That what I always do.

Thank you. Where Total worked.

Usage of Conditional subtotal with Where Total is not working.

SUM
..
COMPUTE test/i10=1;
ON column Subtotal as ' ' when column NE ' '
WHERE TOTAL test GE 1

END

If the column value is NULL, I don't want to display the Subtotal. Otherwise I want to display without column value.

How do I do it?

Why don't you just specify the columns you want a subtotal on?

Ex:
ON COL3 SUBTOTAL COL1 COL2 COL3 COL7 COL9
WHERE TOTAL DUMMY GE 1;

in this example, COL4 COL5 COL6 and COL8 will not be subtotaled...