Conditional column titles
This recipe is meant to introduce you to the Text Source Variable property.
Let's say there is a crosstab report that shows sales quantity by order method (rows) and months (columns). We need to conditionally show full month names or short names depending on the user's selection on the prompt page.
Getting ready
Create a crosstab report with Order method / Order method type on rows, Time (ship Date) / Month (ship date) on columns and Sales fact / Quantity in the intersection.
Create a value prompt on the prompt page with the following specification:
Static choices: Full name, short name
Parameter name: Choice
User Interface (UI): Radio button group
How to do it...
To conditionally show full month names or short names depending on the user's selection on the prompt page, we will use the Text Source Variable property.
Go to Conditional Explorer and create a Boolean variable. Call it Is_FullName and define it as
ParamDisplayValue('choice') = 'Full Name'as shown in the following...
