i have an existing crystal report which came with a piece of software we use.

currently the report will show a list of people with the different charge types associated to them along with the charge amount

ex. peter pan | charge1 | $10 | charge2 | $20 | charge3 | $30

originally this report listed each charge on it's own line.  i enabled the "format  with multiple columns" feature so that all the charges would be listed with the person on a single line.

i'd now like to go further and consolidate the different charges based on the type.

so that for example, charge1, 3, and 5 would be considered type A
charge 2, 4, and 4 would be considered type B

i'd then change the report so that i'd only have 2 columns, type A and type B

for every user underneath each column it'd displayed the sum total of all charges of each type.

using the example above it'd now only show the following:
ex. peter pan | $40 | $20

with that said, how can i achieve this type of logic?  are there any examples or similar reports that someone can point me to for guidance?

thanks.

if you know what your 'types' are and there is an easy way to define them 2 Running Totals will do the trick