Displaying a Cross Tab query on a Form

I'm sorry to ask this, but I just can't figure it out and it's probably
because it's not possible.

I have a Cross-tab query that shows me the sum of items received by
brand(Columns) for every month(Rows). It also has a sum at the end of
each row to give me a total for the month.

I would like to _show_ this on a Form, with a "Year Total" calculated
from the month totals.

A Datasheet view works to show the data rows ( I will be putting it in
a sub form) but I can't get the Yearly total to work(or even show). Is
it something I should put on the main form?

Ideally, I would also like to show the COUNT of submissions by brand
per month. (Each submission contains one or more items). Possibly from
another cross-tab query.

Does this make sense?