Second prompt doesn't show up
Summary:
I'm building a report where the user is supposed to have ability to customize the view by deciding what columns they want to see - all or only selected ones, and how the numbers will be presented - as is, in thousands, or in millions. The former done e via conditional suppression, the letter - via conditional formatting.
To be able to make these selection, we created members such as Show, Do Not Show, As Is, Thousands, and Millions. The selections are defined via prompts. These members were put into Entities dimension due to technical reasons.
The idea is that after making a selection, the report will check what members were selected by analyzing Member Names in selected cells, and will suppress the columns or format the numbers accordingly. That's how the suppression condition is defined, and it works as expected: