Add running total help plz!!!!!!!!!

[Durango122]

Hello
cr 9
ms sql
i have a report that has 2 group
gr 1 contact_id
gr 2 channel

i created a running total for each collumn
i got the number right for the first group base on a distinct count
now i need to add the rsult of this running total to the gr 2 section
ex:
name conference, dinner, lunch
gr 1 charles 1 2 4

that is fine i created a running total and select the field to summarize: type and select
type of summary:distinct count
evaluated i used a formula: type = 'conference'
reset i select on change of group: contact_id

now i need to add the result of each collumn
and return the result for gr 2 channel
i tried a running total
summarize: type and
type of summary:count
evaluated i used a formula: type = 'conference'
reset i select on change of group: channel
but my result is not the amount from gr 1
how can i get the total of the running total for gr 1
to be on group 2

thanks




Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[MrBillSC]

Type of summary for group 2 should be "distinct count" like in group 2.

MrBill

 

[Durango122]

Hi
Mr Bill
i tried that and
in gr 1 for charles dinner = 2
and gr 2 i did the same thing as my first running total but i chane reset to be on channel instead of contact_id i get 1
not 2 as result from gr 1


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40