Hi
I need your help because I didn't find any solution... I wanted to attach the file but I wasn't be able so I attach the image
I have two tables, both of them with textual info.
In the first table I have details about:
- country
- tipe of product
- info about price
and I have to integrate these info with the brand information, that I have in another table where I find association between
- tipe of product
- brand
My ideal objective was to create a pivot table putting all the fields in the rows area to mix these textual info, so for example when I have the Country UK as type of product I'll have just Energy drink and not cola, so - as reported in the attached file - I suppose to see UK --> energy drink --> brand A,B,C and for all of the brands "Waiting for info".
I tried with Power Pivot using the type as look up table but I didn't get what I was looking for (probably Power Pivot is not the right solution)
Hope in your help, many thanks!
I need your help because I didn't find any solution... I wanted to attach the file but I wasn't be able so I attach the image
I have two tables, both of them with textual info.
In the first table I have details about:
- country
- tipe of product
- info about price
and I have to integrate these info with the brand information, that I have in another table where I find association between
- tipe of product
- brand
My ideal objective was to create a pivot table putting all the fields in the rows area to mix these textual info, so for example when I have the Country UK as type of product I'll have just Energy drink and not cola, so - as reported in the attached file - I suppose to see UK --> energy drink --> brand A,B,C and for all of the brands "Waiting for info".
I tried with Power Pivot using the type as look up table but I didn't get what I was looking for (probably Power Pivot is not the right solution)
Hope in your help, many thanks!
Last edited: