Report design - how to make a summary look more like a table

[Laura Linton]

I've tried to find a solution and must not be searching for the correct terms.

My boss wants a statistical report that gives him an idea of how many people are renewing their software subscription and how long they go without renewing. I've created a field called Expired Status (text) that puts each customer into the proper category. I know how to get the totals if I use subsummaries sorted by the different categories. But the format isn't conducive to taking it to the next level that he wants.

He wants a bar graph of the numbers for each product and for the totals. This report that I've made to get the numbers isn't something that can easily be copied and pasted into Excel. The numbers are each on their own line.

Here's a sample:

Product A

Expired Status 1

Expired Status 2

Expired Status 3

Expired Status 3

etc. repeated for each product / status combination

What I'd like is a one line per product report with each status in its own column

Product Name Count for Status 1 Count for Status 2 . . .

Product A 1 10 3 5

Product B 10 . . .

etc.

Is there some way that I can get summaries or perform calculations so that these numbers are more table-like? I'd appreciate any direction you can provide.