As you can see from the "__LeadsPortal" attachment, I am trying to change the way we render total Leads and %Vacant by Property. We now have count, calc and % Vacant fields for each of our 80 properties. I tried doing this by a report, but my boss doesn't like it. I am now trying to put a portal in the Trailing Grand Summary of the report in order to show totals by each prop. However, as you can see, the portal just keeps repeating the last property listed in the body of the report. Where did I go wrong? Can you just not put a portal in the bottom of a report?
I created 3 relationships to try to pull this off: 1) Leads to itself by the Property field, 2) Vacancies to Leads by the Prop field, and 3) Tenants to Leads by the Prop field. I use the latter two only to calculate the %Vacant field, which actually looks like it works. Thanks for your help.