Thread: How do I get running 12 months of data using date filter?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
68jcode 68jcode is offline
external usenet poster
  
Posts: 6
Default How do I get running 12 months of data using date filter?
I am using Excel 2007 connected to a SQL DB and use pivot tables for
reporting purposes. I have multiple years worth of data that I access, but
want to limit my pivot table to display just the last 12 months. I can't
seem to find a way to do this, but am sure someone must have solved this
problem already. I consider myself pretty Excel savvy, but I'm no programmer
so hold the VB please.

Thansk!
Reply With QuoteReply With Quote