I try to create an OLAP table where I can see the reasons why an invoice is being rejected. Since an invoice can be rejected by more than one reason, how can i display all the reasons?
When I do a CASE WHEN it takes the first reason it matches. And is it possible to display more than one reason in one column? E.g. Reason a + Reason b in one column?