I have a pivot table with the blended data in looker studio and the sorting function doesn't work

[EncOS]

I tried adding sort ID filed into the original source and then sort it by that, still no success. Anyone would have a suggesiton?