Using Prompt in a Function with Multiple Selections?
We have a report requirement that a user should be able to select one or multiple parents (the "Departments") in the entity hierarchy and see the level0 descendants of the entity parents in the row of the report (the "Account Keys".) For example, the user wants to select Departments 03, 07, 12, 15 and see the bottom level Account Keys in the row associated with each parent they selected. Another user may want to select Departments 01, 06, 11, and 14. We are unable to built alternate hierarchies to meet this requirements, as the Department selections are very specific and constantly changing.
If I use the "Bottom" function with a prompt, I don't see the option to allow multiple selections in the prompt: