1. Create formulas to capture each value separately
  2. 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)
  3. Click OK
  4. Insert a summary for each formula
For example, if you want to display Cash and Pledge gift amount totals in separate columns:
  1. Create a formula for the Cash gifts: if CnGf_1_Type = "Cash" then CnGf_1_Amount
  2. Create a formula for the Pledge gifts: if CnGf_1_Type = "Pledge" then CnGf_1_Amount
  3. Insert a summary on the Cash formula
  4. Insert a summary on the Pledge formula
  5. The two summary fields can be displayed side-by-side as two separate columns
For example, if you want to display two Blackbaud analytic values in separate columns:
  1. Create a formula for the Target Gift Dollar: if CnPrRat_1_Category = "Target Gift Dollar" then CnPrRat_1_Description
  2. Create a formula for the Major Gift Likelihood: if CnPrRat_1_Category = "Major Gift Likelihood" then CnPrRat_1_Description
  3. Insert a Maximum summary on the Target Gift Dollar formula
  4. Insert a Maximum summary on the Major Gift Likelihood formula
  5. The two maximum summary fields can be displayed side-by-side as two separate columns