Label Filters, Pivot Tables & Formulas

[Duvnjak]

I have created a pivot table from cube data in Excel 2007 that shows revenue by company for 2007 and 2008. I have the Year as my columns and wanted to create a label filter using a formula so that it grabs YTD information:

i.e. Full Date is between '2007-01-01' and '2007-11-19'

However, I can't seem to do this using a formula. Instead I have to type in the date. I wanted to use the formula below so that the filter will grab all the latest data regardless of which day the file is opened.

=TEXT(DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),"YYYY-MM-DD")

Is there any work around for this?

Thanks in advance!

 

[Andrew Poulsom]

You can't enter a formula in the box, but you will probably be able to use VBA. The macro code may give you some VBA code.