Supprimer la hiérarchie dans les tableaux croisés dynamique

%3CLINGO-SUB%20id%3D%22lingo-sub-1990116%22%20slang%3D%22fr-FR%22%3EDelete%20the%20hierarchy%20in%20dynamic%20crossovers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1990116%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI've%20been%20s%20working%20on%20this%20problem%20for%20several%20years.%26nbsp%3B%3C%2FP%3E%3CP%3EEither%20a%20table%20with%20online%20names%20and%203%20columns%20representing%20criteria%20unrelated%20to%20each%20other.%20These%20columns%20include%20the%20value%20of%20%22Yes%22%20or%20%22No%22%20depending%20on%20each%20person's%20situation.%3C%2FP%3E%3CP%3EI%20would%20like%20a%20single%20TCD%20that%20counts%20me%20for%20each%20criterion%2C%20the%20number%20of%20%22Yes%22%3C%2FP%3E%3CP%3EExcel%20fits%20the%20calculations%20and%20nothing%20changes%20if%20I%20select%3A%20Field%20Settings%2FDisposition%20and%20Print%2FShow%20table%20tags.%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20my%20explanation%20is%20clear%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3CP%3ELaurent%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1990116%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Bonjour,

Je bute sur ce problème depuis plusieurs. 

Soit un tableau avec en ligne des noms et 3 colonnes représentant des critères sans liens entre eux. Ces colonnes comprennent la valeur "Oui" ou "Non" selon la situation de chaque personne.

J'aimerai un seul TCD qui me compte pour chaque chaque critère, le nombre de "Oui"

Excel imbrique les calculs et rien ne change si je sélectionne : Paramètres de champs/Disposition et impression/Afficher les étiquettes d'éléments sous forme de tableau.

Je ne sais pas si mon explication est claire?

Merci de votre aide

Laurent

1 Reply

@Laurent_LRH17 

If you mean something like this

image.png

that could be done by Power Query - first unpivot other than Qui columns and after that pivot on values. Generated script is

let
    Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(
        Source, {"Qui"},
        "Attribute", "Value"
    ),
    #"Pivoted Column" = Table.Pivot(
        #"Unpivoted Other Columns",
        List.Distinct(#"Unpivoted Other Columns"[Value]),
        "Value", "Qui",
        List.Count
    )
in
    #"Pivoted Column"