Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=only({$<item_substitute={Healthy_Food_State}::item_substitute>}item_substitute)
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").
PFA