Hi, Tim. I believe I resolved your issue; however, without knowing the layout of your data table, I'm not quite sure if this will help you or not, but maybe it'll lead you in the right direction.
First, I had to create a calculated field called "Reference" to be used in the summary that either represents the Claim # (if present) or the line number. This will provide us something to group the calculations on. It's a character field with the following formula:
In the summary, place "Reference" in the Key Field section and add Count, DOL, Paid, Paid LAE, etc. to the Measure section.
Next, view the properties of the field "Reference" in the Key Field section. On the Matching tab, select the option "Measure limit" --> select DOL in the drop-down menu --> choose the >= operator and specify your limit amount (in this case 1000000).
The final outcome that I received is as follows:
Reference count DOL Paid PaidLae Reserved Incurred
00601 3 $2,450,000 $2,450,000 (Null) (Null) (Null)
00603 2 $1,300,000 $1,300,000 (Null) (Null) (Null)
Line 14 1 $1,700,000 $1,700,000 (Null) (Null) (Null)
Line 5 1 $1,200,000 $1,200,000 (Null) (Null) (Null)
All Others 8 $3,880,000 $3,400,000 $120,000 $620,000 (Null)
Hope this helps,