running total by group
Posted on 2011-03-06
I am trying to create a running total that provides a total based on groups using a formula.
each group has multiple record and the running total is counting each record that is true to the formula, I want to count only 1 for each group no matter how many records are in the group
I am summarizing on InvType
using a count
Evaluating with formula : invType = "callback"
my data looks like this:
if I could evaluate with a formula for each group that should solve the problem?? I Think