Thread: Pivot tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Old Keith Old Keith is offline
external usenet poster
 
Posts: 31
Default 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.