SAC - Sorting functionality fails when aggregation is applied on dimension

[mtayibi]

In SAC i have the following scenarios:

I have a table with Customer ID and Customer Text dimensions. When I sort by Customer Text in ascending order, it works correctly (Scenario A). However, when I add a sum aggregation on Customer ID, the sorting by Customer Text no longer function (Scenario B).

How can i fix this?

Is there any workaround via scripting?

Kr

Ben

[William_Yu1]

Maybe you can first try with 'Break grouping' setting in the sort menu of text column. 

Or you need to create a ticket to SAP, looks like a bug to me. 

In addition, if you haven't tried the new table builder please convert and try it there.