pivot table display (Access 03 SP2)

Topic

New Reply

Edited by HansV to present data in table format

I know this is the STUPIDEST question, but i really don’t feel like looking in a book to figure out why I’m so dumb on this! Why do my pivot tables display differently? I want everything setup like the bottom sample, but i can adjust the settings. is there a simple switch?

month	Data	Total
DEC	Sum of <30	0

Reply | Quote

Replies

In the first example, both Month and Data have been placed in the Row Fields area. You should drag Data to the Column Fields area at the top of the pivot table.

PS You haven’t provided any feedback to your previous questions – that way, other Loungers don’t know whether the replies were helpful.

Reply | Quote

That’s why this question is so crazy. I’ve tried that one before. Both setting are exactly the same.

Reply | Quote

You have asked this question in the Access forum. Your attachment is an Excel file. What’s going on?

Reply | Quote

Because I’m a moron! I keep forgetting where I’m at because I linking up to an access database. Sorry…again! Should I close this one out and open a new post in Excel?

Reply | Quote

I’ve moved the entire thread to the Excel forum.

Have you actually tried dragging the grey ‘Data’ button to where Total is now and dropping it there?

Reply | Quote

Oh my goodness. I knew it was something SIMPLE that I couldn’t figure out. Thanks once again!

Reply | Quote