Forum Discussion
CROISER 2 TABLES EXCEL DANS UN SEUL TABLEAU CROISE DYNAMIQUE
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?
The result should show all products with details like hierarchy from sheet MM + name of supplier from sheet supplier (for example records in red below are correct....supplier of product 53252325 is aeroglass only, supplier from product 53252684 is IFT FILTERS only)
thanks
Hi murielhenaff
Please check the attached if that is or is close to what you were looking for.
https://1drv.ms/x/s!AiUZUhiQtF3Fgt503ym9Bnp2JWcYvg?e=4KlYV8
- yes that's it! great! can you explian how you've managed this issue?