1 Reply Latest reply: Jul 5, 2011 5:59 AM by Kaushik Solanki RSS

    Table join and group query

      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

        • Table join and group query
          Kaushik Solanki

          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