Hello Anaplaner,
Please find the attached Excel sheet along with the use case description below.
We have a use case where the end user requires a selection option on the UX page from a list (Product & Company). As you may be aware, there is currently no option available on the UX page to select multiple list members from a dropdown list, similar to how one would in an Excel pivot table.
We have achieved this result by creating a system model that utilizes the same lists (Product and Company), where we added a Boolean line item for selection and published it on the UX page.
However, the drawback of this approach is that we must use a lengthy formula to attain the desired outcome. While the model is not large, and thus there are no latency issues, it would be greatly beneficial if there were an alternative approach to achieve this result.
Thank you for your attention to this matter.
@rob_marshall @Misbah