@K P - You can create a custom sort calculation like total([Measure] for [SubProduct]) and use that calculation as the advanced sort option for the SubProduct Row.
I've attached a sample report spec for reference. The Report was built using Cognos Analytics 11.1.1 using the Go Sales(query) package.
------------------------------
DENNY NAREZNY
------------------------------
Original Message:
Sent: Wed June 26, 2019 09:31 AM
From: K P
Subject: Crosstab - summary sort
Hi All,
I have below crosstab in cognos and I am trying to sort summary column (Column F) in but it is not working.
Can anyone help me?

------------------------------
- K P
------------------------------
#CognosAnalyticswithWatson