Excel Date Filtered Cubeset Issue when using as cubevalue slicer with PY measures

[TF123]

In Excel 2010 I am using the following cubeset to return a targeted list of customers.

=CUBESET("MyCube", "Filter({[Date].[Date].[All].[2014]}* {[Territory].[Territory Name].[All].[California]}*{[Customer].[Customer ID].Children},([Measures].[Targeted])>= 1)","Cube Set")

This works fine; however I want to use it as slicer to return a cubevalue for net revenue for a previous year. It works fine to return net revenue for the current year (used in the cubeset); however it does not work with my net revenue PY measure (it basically looks like the cubevalue is ignoring the cubeset context and is giving me revenue for all customers in all territories for all time)

Here is the cubevalue formula and A65 is pointing to the cubeset above:



=CUBEVALUE("MyCube","[Measures].[Net Revenue PY]", A65)

My PY measure is:
CREATE MEMBER CURRENTCUBE.[Measures].[Net Revenue PY] AS


Sum( Existing


[Date].[Date].[Month].MEMBERS,

(ParallelPeriod([Date].[Date].[Year]), [Measures].[Net Revenue])

),

FORMAT_STRING = "#,#",

VISIBLE = 1 ,DISPLAY_FOLDER = 'PY' ,ASSOCIATED_MEASURE_GROUP = 'Revenue'


I can get the correct numbers in MDX in Analysis Services or in a Excel pivot able.

Any idea what is going wrong with my cubeset or cubevalue with the PY measures?

Thank you!