I have a 3 column table, one with dollar values, one with posting dates, and one with chemical numbers (8 different numbers). The table is updated daily, and currently sits at 1500 rows.
Our fiscal year stars on 9/1/2008, and I want to sum dollar values of individual chemicals for week periods, starting on 9/1/2008.
How can I accomplish this?
Thanks in advance!
A suggestion (with a posted date in A2):
Add a weeknumber column, with the formula =WEEKNUM(A2-8)
Add a financial year column, with the formula =YEAR(A2)+IF(OR(MONTH(A2)>1,AND(MONTH(A2)=1,DAY(A2)>=9)),1,0)
Then use a pivot table to summarise on chemicals and weeks:
Row values - financial year, week number
Column value - chemicals (this will give you one column for each chemical)
Data value - Amount
You can filter for the financial year values you require on the pivot table output itself.
hth
regards
Mike
Last edited by Mikeopolo; 04-05-2009 at 09:34 PM. Reason: Error in instructions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks