Hello,

I have created a formula that evaluates different info in each line of data and then created a text flag(in the below example, the flag is "A", "B" and "A & B").  What I need to do is to aggregate this flag up to a group level.  Here's an example of what I mean:

Group:        1234

1234        A

1234        A

1234        A

 

Group:        1235

1235    A

1235    B

1235    B

 

Group:        1236

1236   A & B

1236    A

1236    A

 

 

I would like the end result to look like this:

 

Group:        1234         A Only

1235        A

1235        A

1235        A

 

Group:        1235          A & B

1235    A

1235    B

1235    B

 

Group:        1236          A & B

1236    A & B

1236    A

1236    A

 

I would also like to be able to put this into a crosstab that would look at the distinct records at this aggregated group level:

 

            Total                A only              B only              A & B

            3                      1                      0                      2

 

Any help is very much appreciated.