I have this report from 2 related tables (Specifications and SpecInstances, related by FixtureType, not shown in this report). There can be multiple records in the first table for each LoadType. The rows are subsummaries to count the instances of each Zone when sorted by SpecInstances::Zone.
How can I make the 2nd subsummary (Specifications sorted by LoadType) count the # of zones (4 for ELV) instead of the number of records (8)? I tried a fractional calculation field to add up to 1 for each zone, but it only works if the report is based on the Specificaitons database. I need to see all the Zones in SpecInstances.