I have a report with fields F1-F4 in the Detail section. The Data Grouping is on F4. How can I show breakdown for the unique the values in F1 in the Data Grouping?
For example:
F1 F2 F3 F4
A 5 3 Y
G 7 2 Y
G 4 3 Y
R 0 1 Y
Q 9 6 Y
R 2 4 Y
---------------------------------(Data Grouping when F4 changes)
Totals:
F1 F2 F3 #
A 5 3 1 record
G 11 5 2 records
Q 9 6 1 record
R 2 5 2 records


F1 is dynamic; so, I don't know what values will appear.

Jerry