How to output the value of another alternate state

[uacg0009]

Hi all,

I have some data and two lists like below:

one of list's alternate is inherited, another one is GROUP1 that I made.

now what I want is:

if I choose A from ITEM2 and then choose B from ITEM1, the result what I want to show is:

Because only VIP=1 and VIP=3 have bought both A and B, so the number is 2.

How to do it?

Thank you all!

[uacg0009]

Thank you very much tresesco. only is ok for me.

But if I want to choose more than one ITEM, do you have any idea to show all the ITEM that what you choose?

Or there is impossible to do it??

Thank you~

[tresesco]

I don't like saying "Impossible". And here too I believe there would be a work around, possibly using synthetic dimension; pick/match. But that would probably be unnecessarily complex. Concat() is fine for that; you will get the values separated by a delimiter which makes sense for me . What makes you not using that function?

[uacg0009]

For a example, we create a normal table that don't use alternate state. And when we choose ITEM=A,B.

there will be two rows A and B, and show how many vips bought A and how many vips bought B.

"two rows" is important, that is what I want, but the method you and jerem1234 provided is so great and I learnt a lot

from that, so thank you very much and sorry for my serious questions again and again, because I want it better.

In our example, the first column used alternate state(GROUP1), the second column used inherited,

is there have a way to make the second column to show the ITEM like what I said above, not only one row?

Thank you so much!

[tresesco]

See, there is no association between different states. So it makes really no sense putting them in a single chart object. If you select A,B from Group1, and C from inherited, how would you like to see them? two rows for A and B, but one for C which is neither related to A nor B, so on which row? and then what about the count? row-wise ? Better the different state's values in different objects, may be list boxes and the count in text box.