|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
09-17-2008, 10:31 AM
|
#1 (permalink) |
|
Registered User
Join Date: Sep 2008
Posts: 1
OS: Windows XP Pro SP3
|
Using a date filter within a PivotTable
Hello,
Thank you for taking the time to look in to this. I currently have a pivot table and want to create a chart based on that data. The data is based on dates, so as time goes by I'm going to want it display the last 6 months. The closest filter built in is year to date, but I would really like to have a custom filter with something like between Today()-6months and Today. The problem is that Today() gives the error "The date you entered is not a valid date" Does anyone have an idea on how I can get the desired result using something like Today(). I dont want to use actual dates I would like it to be based on when it is when someone opens the file. I'm using Excel 2007, but if you have a solution in Excel 2003 I can try that. If you need any clarifications please ask. Thanks again for your help! -Brian |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
| Thread Tools | |
|
|
