Forum Discussion
Solved
Values in different columns based on different filters
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 ...
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
amitchandak
Super User
Super UserPeRoma , Join both the table on the article
In matrix visual take article on row , Country on column and Sum/Max of price on values
Thanks! I did not expect to be that easy!
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.
