Webi: Unable to sort Cross Table break sections using total variable

[#1]

I have created a Webi cross table which contains a break based on the KMA Market column. I added in a variable to include as the "total" for that break section. My need/goal is to sort all the break sections in descending order based on that total row value. This is my report output example

[RoxanneP]

Removing the default break sort may solve your issue.  But if not, here is a similar example you could follow:

I do not know what to call your 2nd column, but in my example I am using eFashion data and let's use "Category" as an example for that column. 

Add a new column to the left of your total column in the crosstable and add a variable that returns the sum or count of Category for each KMA Market

With eFashion data, this is what it would correspond to:

Category Cnt by Line   =  Sum(Count([Category]) In ([Lines])) 

In your case, it may be the Sum(Sum … rather than Sum(count    e.g. =Sum(Sum([CategoryTotal]) In ([KMA Market]))

Confirm that calculation context is working and that the KMA Market subtotal is matching the variable for each row. 

On the break properties of KMA Market, remove the "Apply sort":

This sort would override your preferred sort.

Now select the whole crosstable and add a  Descending sort on the variable.

You can now hide this column, as it is only needed for sorting purposes.

Results:
 

Let us know if this works for you,
~Roxanne

[nachtaktiv]

Have you tried sorting it yourself yet?
What exactly did you do?
What was the result?

[r-marin_68]

I have highlighted that total field, right-clicked and selected the "Sort -- Descending" option and it does nothing. So either it's not seeing that summary total as a number or something else is missing.