If you'd like to see all that on one line, you'll want to summarize by customer and have calculated columns that only accrue any value if the category is x. Filter out any sales you do not want to see in the totals and call it a day!