Quick question I hope.  I have a report with 3 groups each group sums some dollar amounts and then calculates a percentage based on a parameter field.

 

In the report footer of the report I need to have a summary which shows the percentages of group 1 and then the percentages of group 1 and 2 combined.

 

So my question is, can I create a formula field that goes something like this.

 

"Select {Balance} where {Group Fields} = "Group1 Criteria""

 

Then once I have that formula field I could sum it and use it in the RP Footer?