I have created a report and put in 1 group to summarize per state.
I put one field in the group as the sequential no. so I will know right away the number of states in my report by looking at the last item. The problem is that field is counting the number of record per state which give me the wrong output on that supposed to be sequential no.

Total no. of record=69
Proposed printout

Item no State Buyer
1 California 34
2 New York 20
3 Texas 15


Actual printout
34 California 34
20 New York 20
15 Texas 15

How can I make it to work as per proposed printout?

Thanks for your help.

Ed