Pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

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

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot tables 2
Pivot Table - copy specified Grand Totals 1
Pivot Table Layout 2
grouping dates in a pivot table 1
Subtotals in a Pivot Table 1
Pivot Table Row Totals 6
Pivot Table Summary Error? 6

Back
Top