I want to create a report that includes a count of related records.
The layout is based on a table "Price Tiers". The layout will pull fields from two other tables based on the relationships shown below.
This is a mockup of the report I want to create. I'm having problems getting a correct value for the 3rd column - Count Users in Tier. A calc field in ORGS that counts records in Users is not giving me the correct count. The value in the 2nd column (Count Orgs In Tier) is correct. It shows the total count of all Orgs in each Price tier based on the relationship between Price Tiers and Orgs.
For each Price Tier, I also want to show the total count of Users from the User table. Any help would be appreciated.