subsummary with fields from 2 tables

[nelsonkh]

Is it possible to create a subsummary report with fields from two different tables? I have two tables -- Customers and Lead Cost -- linked by year, lead source and month. I tried to create a subsummary report under the Lead Cost table that breaks down the cost per lead by month, like this:

January 5 leads $100.00 $20.00

February 7 leads $200.00 $28.57

Etc.

Total 12 leads $300.00 $25.00

I used a "Total Count of Leads" field from the Customers table for the subsummary Total, but it is not calculating the total. The Total Cost is a field "Total Cost Incurred" in the Lead Cost table. The only thing I can think of is that FM won't let you create a subsummary with fields from two tables?

Edited September 2, 2008 by Guest