access/excel gurus

[Deleted]

I *think* the day has come for me to learn what a pivot table is. I have an access file with data like this:

Site    Month    Volume2012    Volume2013    Category

I need:
Site    Jan    Feb    Mar ...    Total    Category

So instead of the monthly values in an ongoing column, I need it in a row so I can total it off to the right. Is this where I learn wtf a pivot table is? Or is there another solution? Someone may be able to help me, but he's MIA this morning.

[doxies]

You can do this with a crosstab query in access (similar to pivot table in excel, but since you are saying your data is already in access it might be easier). The query will help you once you select cross tab. You want Site - Group By - Row Heading, Month - Group By - Column Heading and then Volume 2012 + Volume 2013 summed (I think is what you are saying) as the value.

[Deleted]

I think I got it! I do need to export to Excel anyway - I knew the day would come when the one aspect of Excel I've completely ignored and avoided would bite me in the butt.

Thanks doxies!

[djc315]

Pivot table "guru" checking in

They are super simple... and yes, you can use it to total the months.

I would suggest using a new tab, Go to the "insert" menu , click on pivot table, highlight your entire data set (need headers, too). Then, you'll be able to drag the headers into the format you want in the PivotTable field list on the right.

To get what you need, drag Site, then Month to the Row Labels, and then Volume (Or whatever $$ row you have) to the values. You can have multiple items in the row labels and the values. The row labels can be expanded or collapsed by right clicking on them in the actual pivot table (not the field list).

Let me know if that makes sense and if it works!