Dynamically filter a MemberSet using a Property
I need to filter a MemberSet in an Expansion based on the CV selection. The property value cannot be hard coded, since it needs to flex as a different item is selected in the CV.
Here is the desired result
ARR_ITEM = "Y" AND ARR_PAGE = "???"
where ??? is equal to the property of the CV selection
Thats because of the format of the cell of the member set it's not the correct format, for changing it , you can copy the cell where you made the calculations (or a cell that shows you the result of calculation instead of the formula) and paste it over the member set cell, then put the formula as before and now the will recognice it as a formula and it will put the result intead of the formula,
hope it helps