We have a requirement of creating a summary report based on a secondary data.
There are 3 tables:
2) Location - Location name, Geography.,
3) Project Location which has many to one relationship with the above 2 tables
I just need to report number of projects corresponding to each geography.
When I create summary report to display count of Project Locations grouped by Geography, I'm not getting the proper count.
For example: There are 2 locations that belong to same geography assigned to a project, then the Geography should have count as '1' instead of '2'.