You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Second prompt doesn't show up

Accepted answer


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:

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!