Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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