Filtres sur plusieurs champs dans un TCD

%3CLINGO-SUB%20id%3D%22lingo-sub-1580713%22%20slang%3D%22fr-FR%22%3EFilters%20on%20multiple%20fields%20in%20a%20TCD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580713%22%20slang%3D%22fr-FR%22%3EHello%2C%20%3CBR%20%2F%3E%20I%20want%20to%20know%20if%20it%20is%20possible%20to%20accumulate%20several%20value%20filters%2C%20on%20different%20fields%2C%20in%20a%20TCD.%20For%20example%2C%20in%20simplified%20version%20on%20the%20attached%20table%2C%20I%20would%20like%20to%20show%20the%20top%2010%20products%20in%20terms%20of%20sales%2C%20and%20whose%20costs%20are%20less%20than%201.5.%20When%20I%20filter%2C%20I%20either%20one%20or%20the%20other%2C%20but%20impossible%20to%20have%20both!%20%3CBR%20%2F%3E%20Thank%20you%20and%20have%20a%20good%20day!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1580713%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582570%22%20slang%3D%22en-US%22%3ERe%3A%20Filtres%20sur%20plusieurs%20champs%20dans%20un%20TCD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F154942%22%20target%3D%22_blank%22%3E%40Flavie%20Wattinne%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epls%20see%20my%20sol%26nbsp%3B%3C%2FP%3E%3CP%3EI%20added%20a%20rank%20column%2C%20then%20use%20it%20in%20the%20pivot%20table%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Bonjour,
Je souhaite savoir s'il est possible de cumuler plusieurs filtres de valeurs, sur des champs différents, dans un TCD. Par exemple, en version simplifiée sur le tableau joint, je voudrais afficher le top 10 des produits en termes de chiffre d'affaires, et dont les coûts sont inférieurs à 1.5. Quand je filtre, j'ai soit l'un soit l'autre, mais impossible d'avoir les 2 !
Merci et bonne journée !
1 Reply

@Flavie Wattinne

 

pls see my sol 

I added a rank column, then use it in the pivot table