Subtotal of items in a list

[ontherevenue]

I have a repeating group that i need to filter?

this group has a list of items with multiple entries for each item i need to get the subtotal of each item returned not a list of each entry and the amount for that item.

Items:
Fuel $12.00
Tires. $100.00
Gas. $40.00
Fuel. $35.00
Tires. $50.00

What i would like returned is as follows

Fuel. $47.00
Tires. $150.00
Gas. $40.00

Any ideas on how i can achieve this

[adamhholmes]

Use Group by, to group by a certain field, then you can use the sum of each grouping.

[ontherevenue]

think I figured out the group by

now I would like to filter by a date range. The way I normally filter by date does not seem to be working. Where do I need to add the filter? Or do I need to use something different