LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
qadie
 
Posts: n/a
Default how do i set up a three dimensional table

How do I set up a three dimensional table in order to easily get the totals
based on both rows and columns? Names will be on the left as will be
categories of type of volunteer work. Columns will have months of the year
as well as Totals for each category. I tried using Pivot Tables but they
work off of a 2 dimensional table. I know this must be easy but I just
can't figure it out at 2 a.m. Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
table dow Excel Discussion (Misc queries) 0 January 12th 05 02:25 PM
table dow Excel Worksheet Functions 0 January 11th 05 05:17 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"