=CUBEMEMBER Function

[Duvnjak]

Hello,

I am wondering if someone can help me. I created a pivot table and then converted the pivot table to be formula based.

I am trying to create a YTD report based on the years 2008 and 2009. Is it possible to modify the CUBEMEMBER function for each YTD column?

i.e.

=CUBEMEMBER("Invoice Cube","[Invoice Date].[Full Date].[2008-01-01 00:00:00]:[Invoice Date].[Full Date].[2008-03-10 00:00:00]")

This would show everything for YTD 2008 (of course, I would change the hardcoded values to formulas later on). However, the above statement is not working for me.

I can change the above to the following to get data for March 10th only:

=CUBEMEMBER("Invoice Cube","[Invoice Date].[Full Date].[2008-03-10 00:00:00]")

However, I'd really like to know if I can do this based on a range.

Thanks in advance to anyone who has some input!

 

[Duvnjak]

Sorry, I forgot to add that I am using Excel 2007.