Creating a table with sub categories

Hi,

I am sure I am being slow here but i am struggling with what seems basic.

I want to detail a list of customers and numbers of requests per month. So far so good, I have a list of customers in column A then a row of concurrent months in row 1. I was detailing the number of requests per month for each customer easily but now i also want to detail information on sub-category of requests, so Total Requests and Specific Requests.

Is there a way to do this without creating a new table?

Thanks in advance for any assistance!
A

Just expanding on Pauley's post, here is a starting point using a simple pivot table.

customerRequests.png

Cols A thru C are your data entry in this example.
Col-B records your "Request Subcategory" and col-C a request date. Col-D is automatically calculated to get the month of the request. In D2 copied down:

Formula:

Please Login or Register  to view this content.

As uploaded, the pivot table in G1:K8 shows the total number of requests per customer per month - this should match the report that you currently have. Via the cell H1 filter you can specify that the report is restricted to one or more request subcategories. Beyond that, there's potentially all sorts of ways to summarize your data using the pivot table "drag and drop" interface.

The attached workbook implements the above.

Let us know if this is along the lines of what you are looking to do.