Calculating between 2 tables in one report

Goodmorning,

In one report I have 2 tables. Both tables are related to a different data set. Now I want to create a calculating between a field of the table 1 and a field of table 2.

Does anyone know how to?

Thx anyway!

I have the same problem.

My tables(matrices) look like this:

Revenue Report(matrix)

Jan Feb Mar .........

Account 1 $100 $200

Account 2 $50 $300

Subtotal $150 $500

Expense Report (matrix)

Jan Feb Mar .........

Account 1 $100 $100

Account 2 $0 $300

Subtotal $100 $400

Grand Total $50 $100

I need the Grand Total for each month (subtract Expense subtotal from Revenue subtotal)

|||

Both of you can use this AMAZING trick! Very powerful.

Simply store the totals of your first table in a dictionary, do the same for your second table. Then, to get the grand total simply retrieve the values and add them up.

Here is a link to a post that will explain you what I mean by 'dictionary':

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1129743&SiteID=1

|||

Thx Choquette for your answer!

I've used my free weekend for devolping a different solution. Its only usefull for my specific situation. In short: I've created a new dataset, summing the totals of that new dataset en used it in my calculation.

If I have the time I would absolutely try your suggestion. Thx again!