- Create formulas to capture each value separately
- Insert a summary on each formula
- From the first drop down, select the first formula
- From the second drop down, select the summary type (for example: Sum)
- From the third drop down, select the group you would like to subtotal each column for or choose Grand Total (Report Footer)

- Click OK
- Insert a summary for each formula

- Create a formula for the Cash gifts: if CnGf_1_Type = "Cash" then CnGf_1_Amount
- Create a formula for the Pledge gifts: if CnGf_1_Type = "Pledge" then CnGf_1_Amount
- Insert a summary on the Cash formula
- Insert a summary on the Pledge formula
- The two summary fields can be displayed side-by-side as two separate columns

- Create a formula for the Target Gift Dollar: if CnPrRat_1_Category = "Target Gift Dollar" then CnPrRat_1_Description
- Create a formula for the Major Gift Likelihood: if CnPrRat_1_Category = "Major Gift Likelihood" then CnPrRat_1_Description
- Insert a Maximum summary on the Target Gift Dollar formula
- Insert a Maximum summary on the Major Gift Likelihood formula
- The two maximum summary fields can be displayed side-by-side as two separate columns