Pivot Table Dates

L

Liz J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top