If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table Dates
I have a pivot table that takes data from 6 columns:
A - Current Yr Week (1, 2, 3 ...) B - Current Detail Date (1/1/09, 1/2/09, 1/3/09 ...) C - Last Year Week (1, 2, 3 ...) D - Last Year Detail Date (1/1/08, 1/2/08, 1/3/08 ...) E - Current Yr Unit Cost F - Last Year Unit Cost My goal is to have this daily information compiled into weeks (totaling at each Saturday). Since columns B and D have daily values, to get true week end values, I would need to have 3 columns in my pivot tables: A - Week # - 1, 2, 3 ... B - 2008 week (listing down the column like this, for each Saturday: 1/5/08, 1/12/09, etc.) C - 2009 week (1/3/09, 1/10/09, etc) I'm sure something like this is possible, but I'm not sure how to do it? Any suggestions would be greatly appreciated! Thank you for your time and help! |
#2
|
|||
|
|||
Pivot Table Dates
Excel 2007 Pivot Table
Group by week, compare by year. http://www.mediafire.com/file/zumqx4...10_07_09a.xlsx |
Thread Tools | |
Display Modes | |
|
|