Hello,
I have multiple tables that I have I add to data model, in which I create a pivot table.
However, since the [Amount] column were from different tables, pivot table is showing me 3 different columns, instead of 1.
May I know, how do I go about doing it and show it like the 'classical' pivot table.
Below is an image of how the tables were done, and the desired result.
I have multiple tables that I have I add to data model, in which I create a pivot table.
However, since the [Amount] column were from different tables, pivot table is showing me 3 different columns, instead of 1.
May I know, how do I go about doing it and show it like the 'classical' pivot table.
Below is an image of how the tables were done, and the desired result.
![7cBJt7c.png](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2F7cBJt7c.png&hash=cfb2a42251503717ac074357ccbe7196)