set analysis using fact as dimension or a variable

[#1]

Hi,

    I have a following expression. Based on a button the variable var changes

if( var=DATE_FY, sum({<DATE_FY={'2013'}>}AMOUNT),sum({<DATE_CY={'2013'}>}AMOUNT))

I want to remove the if condition from the expression. So I create a Inline table Period with values as DATE_CY, DATE_FY  and trying to use them in my expression. By default Period is DATE_FY.

=sum({<$(Period)={'2013'}>}AMOUNT)

This doesn't seem to work.

Is there a way to make this work ?

Thanks

Lax

[er_mohit]

You have to write two expressions

=sum({<DATE_FY={'2013'}>}AMOUNT)

For this in conditional check on it and write =Period='DATE_FY' in Conditional is

and same for other expression sum({<DATE_CY={'2013'}>}AMOUNT)

and in conditional write =Period='DATE_CY'

hope it helps

when you select in list box it works

[#3]

Hi,

     I wish to use single expression only.

Thanks

Lax