Forum Discussion
CROISER 2 TABLES EXCEL DANS UN SEUL TABLEAU CROISE DYNAMIQUE
Bonjour, je souhaite créer un tableau croisé dynamique à partir de 2 tables excel situées dans le même classeur excel (1 table avec le nom et la date de naissance, 1 table avec le nom et l'adresse)
j'ai créé une relation entre les 2 tables (la clé commune est le nom de la personne) mais quand je crée mon tcd, il me renvoie tous les enregistrements (le nom, la date de naissance et toutes les adresses.
j'imagine que j'ai zappé une étape mais laquelle?
merci par avance de votre aide.
7 Replies
Hi murielhenaff
What is a tcd? Please show us the steps in how you create the tcd.
a TCD is tableau croisé dynamique in french...pivot table in english
I've got 2 sheets:
- sheet MM with all products created for my organisation with details such as weight, hierachy, category...,
- Sheet supplier with same products and name of supplier (one product has only one supplier)
I have created a relation beetween those 2 sheets through power pivot. the article is the common value.
then I need to create a pivot table, with material reference, description, hierarchy, ...and name of supplier.
but the results are wrong as each material is displayed to be linked to all suppliers 😞
I guess that when creating the relation, I need to get a one to one relation. but I can't change this parameter (it is always multiple to one).
can you help me?
Hi murielhenaff
What does the expected result look like? What should the pivot result look like?
In other words what is the parameter for the query (beggar?).
example: I am looking for product x to find out which supplier is providing product x
or I want to see all products that the unit of measure is KG, or M2, or P, or PC
so what is the beg?
