Pivot tables
I have downloaded my credit card details over the years into Excel. What I'd
like to do now is to have Pivot produce a report showing just the amount spent for each month, with the years grand total. Is there a simpler way of doing this,other than adding another column with a lookup entry that returns the months, as I'm doing now? Thanks in advance. |
Pivot tables
Old Keith -
If your data have a date/time field that contains actual dates and times (not text), then you can use a Pivot Table to group by month and year (and then hide the details). - Mike http://www.MikeMiddleton.com "Old Keith" wrote in message ... I have downloaded my credit card details over the years into Excel. What I'd like to do now is to have Pivot produce a report showing just the amount spent for each month, with the years grand total. Is there a simpler way of doing this,other than adding another column with a lookup entry that returns the months, as I'm doing now? Thanks in advance. |
Pivot tables
Hi Mike,
I'm using Excel 2007 and I just can't seem to navigate the route your talking about.Can you lead me a bit more? Old Keith "Mike Middleton" wrote: Old Keith - If your data have a date/time field that contains actual dates and times (not text), then you can use a Pivot Table to group by month and year (and then hide the details). - Mike http://www.MikeMiddleton.com "Old Keith" wrote in message ... I have downloaded my credit card details over the years into Excel. What I'd like to do now is to have Pivot produce a report showing just the amount spent for each month, with the years grand total. Is there a simpler way of doing this,other than adding another column with a lookup entry that returns the months, as I'm doing now? Thanks in advance. |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com