Table join and group query

[#1]

I have 3 database tables.

TableOne

Key     DataOne

1          A

2          B

TableTwo

Key     DataTwo

1          10

1          15

2          20

TableThree

Key     DataThree

1          50

1          60

2          200

2          210

How to obtain a report as below.

DataOne     SumOfDataTwo     SumOfDataThree     SumOfDataThreeMinusSumOfDataTwo

A                    25                              110                                             85

B                    20                              410                                             390

[kaushiknsolanki]

Hi,

   Create a straight chart.

   Include Dataone as Dimension.

   Expression as Sum(DataTwo) For SumOfDataTwo

   Sum(DataThree) for SumOfDataThree

   Sum(DataThree) -  sum(DataTwo)

                    Or

   Column(2)- Column(1)

Regards,

Kaushik Solanki