Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 table which is not connected with any field. (Just for sample i mentioned 2 tables)
Now i need the Sum value based on the Table1 Dimension. see the below,
I tried with Concat(Distinct Table2.Sorg,',') in the set analysis.
Table1 | Table2 | |||||
YearMonth | Sales Org | Sales | YearMonth | Sorg | Sales | |
201501 | 1000 | 235 | 201501 | 1000 | 482 | |
201502 | 1000 | 310 | 201502 | 1000 | 475 | |
201503 | 1000 | 891 | 201503 | 1000 | 482 | |
201501 | 2000 | 668 | 201501 | 2000 | 313 | |
201502 | 2000 | 729 | 201502 | 2000 | 500 | |
201503 | 2000 | 966 | 201503 | 2000 | 219 | |
201501 | 2500 | 132 | 201501 | 2500 | 434 | |
201502 | 2500 | 425 | 201502 | 2500 | 270 | |
201503 | 2500 | 942 | 201503 | 2500 | 409 | |
201501 | 3000 | 754 | 201501 | 3000 | 229 | |
201502 | 3000 | 124 | 201502 | 3000 | 391 | |
201503 | 3000 | 287 | 201503 | 3000 | 227 |
Expected output
Any Help on this?