Values in different columns based on different filters

[PeRoma]

Hi,

I want to show in a table visual 2 columns that are based on the same data column with different filters: My fact-sheet contains prices for articles in different countries. There is a dimension with all articles. I want to create a table visual that shows prices of different countries in different columns of one row.

Thanks for any ideas!

PeRoma

Article Table			Price Table
article	category		article	country	price	since
a	c		a	U	2	1.2.
b	d		a	M	3	2.1.
c	e		b	C	4	4.3.
			b	M	6	6.12.
			c	C	7	7.4.
			c	U	8	5.7.
The Table I want to have
Article	C	U	M
a		2	3
b	4		6
c	7	8

[amitchandak · Accepted solution]

@PeRoma , Join both the table on the article

In matrix visual take article on row , Country on column and Sum/Max of price on values

[PeRoma]

Hi amidchandak,

the solution has been to easy to be true. But this is, because I did not tell you everything: I need some more columns beside these "aggregated" columns. So I am stuck with a Matrix. Is there another way for this problem? I would like not to modify my data-sheets.

[PeRoma]

Thanks! I did not expect to be that easy!