Group count on each detail record - possible? 1

[wanderingaround]

Hello - I'm having trouble with counts!!

I've grouped my data and set up a count in the group footer but I want that count to be displayed next to each record in the details...

This is what I want to acheive:

Client Action Count
123 sale 2
123 buy 2
321 buy 1
666 sale 3
666 buy 3
666 frog 3

This is what I'm getting:

Client Action
123 sale
123 buy
total: 2
321 buy
total: 1
666 sale
666 buy
666 frog
total: 3

Any tips? once again i've fried my brain trying to figure it out... thanks, Mike

 

[lbass]

Create a formula like this:

count({table.client},{table.client})

...and place it in the detail section. For the first field in the summary you can use any recurring (non-null) field.

-LB

 

[wanderingaround]

I want to have your babies - thank you so much LB


Mike