In CrossTab tool, it have Total Row and Total Column as option.
For Total Row, it work all the sum, count, and avg etc.
but for "Total Column", it only sum (even i not select the sum)
To solved this I suggest to add Total Column for Count, Avg and etc.

version 2024.2
