September 2, 200817 yr 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, 200817 yr by Guest
Create an account or sign in to comment