Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


where ??? is equal to the property of the CV selection

Former Member
Former Member replied


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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question