Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate state in calculated dimension - Set analysis

Guys,

I have two alternate states, one is <inherited> the other one is <Healthy_Food_State>...

I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...

Can you guys say to me a possible expression?

I am trying something like:

=only({$<item_substitute= ::[Healthy_Food_State]>}item_substitute)

I do suck at those kind of expressions.

Can you guys tell me a possible solution for that?

3 Replies
Not applicable
Author

=only({$<item_substitute={Healthy_Food_State}::item_substitute>}item_substitute)

Not applicable
Author

it didn't work, try to see here the attachment:

in the third blue box we have the chart called "Saving"... The calculated dimension is in there. I want to get the item_id from the other state, (i want the item_id as in the second blue box, in the blue chart called "Food Price").

Not applicable
Author

PFA