Combine Summary reports
Background Info: I am using the following
- Filemaker pro Advanced 11
- Mac OS X 10.6.4
- Single user mode
- Just started using Filemaker
I have two tables that summarise different data by client and then account. I would like to combine the summarised data into a single report however I am having problems getting the desired results. Whichever table I base the layout on, I can get the summarised data from that table but when I try and incorporate the summarised data from the other table it will only summarise by client and not by client and then account. I have made sure that I have sorted both table by client and account but that does not seem to make any difference.
Firstly, I assume that it is possible to achieve a combined report as described and, secondly, can anyone suggest a solution.