GeorgeSalet
asked on
running total by group
Hi Experts
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"
Reset never
my data looks like this:
Group 1
callback
callback
==========
1
Group 2
callback
============
1
if I could evaluate with a formula for each group that should solve the problem?? I Think
George
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"
Reset never
my data looks like this:
Group 1
callback
callback
==========
1
Group 2
callback
============
1
if I could evaluate with a formula for each group that should solve the problem?? I Think
George
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Perfect
Thanks for the help
George
Thanks for the help
George
Group 1
callback
callback
==========
1
Group 2
callback
============
2
mlmcc