This video will demonstrate how to use a prompt macro, case statements, a prompt control with static choices, and conditional formatting to dynamically control which columns are displayed in a report and how they are displayed.
The syntax used in this technique is provided below.
Prompt Macro Syntax
#prompt('Report Type', 'token', '[Sales].[Order Method].[Order Method]')#
Case Statements Syntax
When (?Report Type? = '[Sales].[Order Method].[Order Method]')... [Continue Reading]