Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

Independent table with Sum in Set analysis

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
YearMonthSales OrgSales       YearMonthSorgSales
20150110002352015011000482
20150210003102015021000475
20150310008912015031000482
20150120006682015012000313
20150220007292015022000500
20150320009662015032000219
20150125001322015012500434
20150225004252015022500270
20150325009422015032500409
20150130007542015013000229
20150230001242015023000391
20150330002872015033000227

Expected output

Capture.123JPG.JPG

1 Reply
settu_periasamy
Master III
Master III
Author

Any Help on this?