Link to home
Create AccountLog in
Avatar of GeorgeSalet
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
Avatar of Mike McCracken
Mike McCracken

So what you want is

Group 1
  callback
  callback
==========
       1
Group 2
  callback
============
        2


mlmcc
ASKER CERTIFIED SOLUTION
Avatar of GJParker
GJParker
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of GeorgeSalet

ASKER

Perfect
Thanks for the help
George