Intersection of Selections issue

[#1]

Hi,

I am trying to transfer the intersection of selections in Group 1 and Group 2 to a third Group 3 using alternate states.

The button uses the following expression

='(' & Concat({Group1 * Group2} Order_No, '|') & ')'

Question - Why would my pivot table show 'Closed' when I don't have it selected? See image below.

Any help would be greatly appreciated.

[tresesco]

Possibly because, you are forcing the selection  only for common Order_No. If you have to consider the Status too, you have to similarly force the selection for Status as well. That is create another similar action for Status and apply it on the same button click may be.