Totals for group members

[simma]

Hello I have data something like this

Group A PAT Type----BK
name date type
Pat 01/02/02 BK
Pat 01/03/01 ND
Pat 01/04/00 ND
Group B GAN Type----ND
name date type
Gan 11/02/02 ND
Gan 06/03/01 BK
Gan 01/04/00 ND

The above groups are based on names.I want the number of types.A group is said to be of certain date based on latest DATE.For example the first group is of type BK becos on lastest date its type BK.Now I want the totals of types.I cant group it becos of previous types.Please advice.
Thanks

 

[synapsevampire]

I don't understand the requirement.

Do you want the number of Types per Group, or the number of types that are of type BK, or???

Show what you have, and show what you want.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[simma]

Thanks synapsevampire
I want number of types that are of type BK... I want the total number of types of each group.say two groups of type BK then the total number is 2.The type of group depends on the type on latest date..Hope I made my self clear
Thanks...
Group A PAT Type----BK
name date type
Pat 01/02/02 BK
Pat 01/03/01 ND
Pat 01/04/00 ND
Group B GAN Type----ND
name date type
Gan 11/02/02 ND
Gan 06/03/01 BK
Gan 01/04/00 ND

The above groups are based on names.I want the number of types.A group is said to be of certain date based on latest DATE.For example the first group is of type BK becos on lastest date its type BK.Now I want the totals of types.I cant group it becos of previous types.

 

[simma]

I found the solution thanks...
I created two formulas

1.t1---groupheader
WhilePrintingRecords;
if OnFirstRecord = false then
if{QryFsv_NodQ.FldApApprType}="BK" then
numberVar RunningTotal:= RunningTotal+1
2.t3 groupfooter
WhilePrintingRecords;
numbervar runningtotal;