Pivot table sorts by order of the dimensions. The closest to your requirement that I could get was adding calcualted dimension on the second place, right Commune, and sortin it by numeric descending: aggr(count(distinct if(FL_SLL_VALIDE_ENGIN=1,CLE_DEPART_ENGIN)),LIB_CENTRE_APPEL1_COMMUNE,LIB_CENTRE) You can hide it the same way as you did with another calculated dimension. Note, that partial sums in this case should be done by this new dimension.
