Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MTD Weekly Cumulative
Does anyone have an idea how I can take a group of sales numbers and figure
out the MTD Weekly cumulative? I have a worksheet that has the sales figures for each day of a given month. My boss wants to figure MTD weekly cumulative. I am clueless and you all seem soooooooooooooooo smart. Please help:) -- KathyP |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MTD Weekly Cumulative
You can use a pivot table and drag the dates header to the row and the sales
to the data, click finish, the right click in the table and select group, then clear month and select days and then in the number of days select 7 and click OK Could look like something like Sum of Sales Dates Total 11/1/2007 - 11/7/2007 20 11/8/2007 - 11/14/2007 22 11/15/2007 - 11/21/2007 20 11/22/2007 - 11/28/2007 22 11/29/2007 - 11/30/2007 6 Grand Total 90 -- Regards, Peo Sjoblom "KathyP" wrote in message ... Does anyone have an idea how I can take a group of sales numbers and figure out the MTD Weekly cumulative? I have a worksheet that has the sales figures for each day of a given month. My boss wants to figure MTD weekly cumulative. I am clueless and you all seem soooooooooooooooo smart. Please help:) -- KathyP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CUMULATIVE TOTALS | Excel Discussion (Misc queries) | |||
with weekly score sheet how do I column a weekly progressive aver. | Excel Worksheet Functions | |||
How to calculate the cumulative weekly average over several wksht | Excel Discussion (Misc queries) | |||
Cumulative Sum | Excel Worksheet Functions | |||
Cumulative Frequency | Charts and Charting in Excel |