Alternate States and set analysis

[#1]

Guys, I am having a trouble trying to make it appear the "item_id" from the state "Healthy_Food_State", in the chart "Saving" (in the third blue box in the table...

the item_id that are supposed to appear are like D,E,F,G...

Can you guys help me out with this set analysis?

[whiteline]

Hi.

It's incorrect syntax. Use square brackets to get the alternate state.

Also for calculated dimension you have to use aggr() function.

aggr(only({$<item_id=[Healthy_Food_State]::item_id>}item_id), item_id)

[#3]

Thank you, but it is not showing what I want...

The selection is: "Hamburguer" in the first blue box, and then "Hamburguer Replacement" in the second blue box...

If you then put the "item_id" in a list, you will see in the "inherited" state the number 1 only, if you change to "Healthy_Food_State", it will show F,E,G,D... It seems that the field in the Healthy_Food_State is not being shown....

Do you know how to make that work this way?