Forum Discussion
Solved
Sort multiple level row header in matrix
Hello, I want to achieve the following presentation with a matrix : (these are row headers) I cannot find a way to sort the second level by alphabetical order đ¶ I have tried th...
I've found a trick to solve my problem: I add a space after the word if I have duplicates.
This way, I can sort the labels by the sort keys.
A bit far-fetched, but in my case it works...
Well...I guess I have another difficulty đ€
The values of the matrix are two columns like that :
CA =
VAR __CAType = SELECTEDVALUE ( FPX_Hierarchie[CA Type]; "Non sélectionné" )
VAR __Categorie = SELECTEDVALUE ( FPX_Hierarchie[Categorie]; "Non sélectionné" )
RETURN
IF (
__CAType = "Non sélectionné" || __Categorie = "Non sélectionné";
// DĂ©bogage visuel
"SĂ©lection manquante : " & __CAType & " / " & __Categorie;
// Sinon, exécuter le SWITCH :
SWITCH (
TRUE();
__CAType = "CA Comparable" && __Categorie = "Intégrés"; [CA_FPX_COMP_INT];
__CAType = "CA Comparable" && __Categorie = "Masters Franchisés"; [CA_FPX_COMP_MASTERS_FRA];
__CAType = "CA Total" && __Categorie = "Intégrés"; [CA_FPX_TOT_INT];
__CAType = "CA Total" && __Categorie = "Masters Franchisés"; [CA_FPX_COMP_MASTERS_FRA];
__CAType = "CA Total" && __Categorie = "Franchisés"; [CA_FPX_TOT_FRA];
BLANK()
)
)
Therefore, I cannot link this with the new column CompositeCategorie...
Is there is another way to do it ?
Thanks !
I've found a trick to solve my problem: I add a space after the word if I have duplicates.
This way, I can sort the labels by the sort keys.
A bit far-fetched, but in my case it works...