Suming rows (average)

Hi! 

My data looks something like this :

When I make a table it ends up adding all the $500s for Folder 300 to make my total $1500. The total I want is actually $500 because order 10024+10025+10026 =500. 

For 301, the total i want is $20, but it adds both up to make it $40

I tried using distinct or average, it throws off the totals of the table and just averages EVERYTHING.

Any tips?

Thanks!

Anyway to add a new columns that will make my data look like this