Calculations with different parts of a found set
So I have a found set of records. I want to take the percentage of a certain type of records can I write a calculation field that sums up say revenue from all the records in my found set. And then by some criteria, for example the orders have to be made by members, and sum the revenue from those selected records within the found set.
The purpose would be to get the percentage so then I would divide the member order revenue, by the total revenue in a calculation field. Or can I not isolate different parts within the found set?