I have attempted to set-up a Gridview for my purposes, but am struggling with what I need. Is there a way in Gridview to subtotal not as a whole, but per category in a row?

I ultimately want a report that shows me by customer # the total dollars spent in 11 categories...totaled by category for specific dates (which I'm assuming would be calculated columns?).

TGIF!