Calculated Dimension date set analysis

[#1]

Hi All

I have a date Calculated dimension which returns for my table only this and last FY.

As this is a calc dimension if I select 2013 it is reducing the data to only the one FY. I would like it to show always the two FY as per the calc date Dimension  regardless of the date selections.

I have sucessfuly performed Set analysis for expresssions - however am struggling for the calc dimension.

I have been playing with the below logic - could someone point me in the right direction pls.

=if(FinancialYear=vCurFY,vCurFY, If(FinancialYear=VCurFYPrev,VCurFYPrev))

//=if({<FinancialYear = {$(CurFY))} ,

DateVal=,FinancialYear=,

FinancialPeriod=,

FinancialWeek = >}

Thanks

Jo

[alexandros17]

in set analysis if you want to exclude a selection for example myField you have to

Example:

sum of myVal not considering selection of  myField:

sum({$<myField=>} myVal)

hope it helps

[#3]

Hi

Thanks for your response.

The field I want to exclude selectio0ns from is a Date so Im not sure how to set the expression out.

Thanks

Jo