Forum Discussion
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 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 |
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
3 Replies
- amitchandak
Super User
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
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.
