Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created the following set expression and it is working fine.
sum( {1<[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]={"$(=Only([R_MONTH]))"}>} [PREMIUM] )
I have two other dimensions in my chart 'TO_MONTH' and 'TYPE' I want to modify the above expression to extract data where I want fulfill following conditions
1 R_YEAR] = {"$(=Only([R_YEAR]))"
2 [R_MONTH] not equal to TO-MONTH
3 TYPE='F'
Pls help me to rewrite the Set expression
sum( {1<[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]-={"$(=Only([TO-MONTH]))"},TYPE={'F'}>} [PREMIUM] )
sum( {1<[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]-={"$(=Only([TO-MONTH]))"},TYPE={'F'}>} [PREMIUM] )