Alternate state prb

[#1]

Dear Community please follow th image

in the above senario instead of groups i need t disply banges replace by group1   and Anchovies replace by group2

[tresesco]

Write expression like below for both of the expressions:

=Only({[Group 1]}[Product Sub Group])

=Only({[Group 2]}[Product Sub Group])

[simondachstr]

Or =Concat({altstate1} [Product Sub Group])