Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table: How do I make a monthly breakdown of daily data?
I have my data organized as date in column A, amount in column B and category
in column C, e.g. 3. Aug 2009 spent $ 200 on clothing and 4. Aug 2009 spent $50 on restaurant. I would like to keep track of montly spending on each category and the total of each month. My problem is that the date dimension doesn't seem to be possible to group to a higher level than on the actual date from the data level. How do I do it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Monthly Breakdown | Excel Worksheet Functions | |||
sum daily production data to monthly | Excel Worksheet Functions | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Pivot Table with Data Added Monthly | Excel Discussion (Misc queries) | |||
Monthly Budget Breakdown | Excel Discussion (Misc queries) |