1 . Set the aggregates in your Pivot process but don't show them in PivotMatrix with "measure" property and sort by such aggregates with "rowSort" or "columnSort" property:

https://www.koolreport.com/docs/pivot/pivottable_and_pivotmatrix/#properties-measures

https://www.koolreport.com/docs/pivot/pivottable_and_pivotmatrix/#properties-sort

2 . You can hide grand total/sub total rows/columns with "hideGrandTotalRow", "hideSubTotalRows", "hideGrandTotalColumn", "hideSubTotalColumns" properties.

3 . Don't use "partialProcessing" in your Pivot process should make your PivotMatrix expanding all sub rows by default. Don't use "rowCollapseLevels", "columnCollapseLevels" property in PivotMatrix as well.