Show/Hide crosstab colums based on prompt selection(static choices)

[samiar784@gmail.com]

Hi,

In my cross tab I have  country field as rows,Sales and Orders as measures. I created a prompt with parameter name selection with two static choice values like Sales and Orders.

My requirement is as below:

Req 1) When I select 'Sales' from the prompt during run time only Sales measure should be visible in Cross-tab.
Req 2) When I select 'Orders' from the prompt during run time only Order measure should be visible in Cross-tab.
Req 3) When the report is run without selecting any values then both Sales and Orders need to be displayed in the Cross-tab. (I should not be using ' none ' or 'both ' as a third Static choice value.)

To achieve the same

I  created a data item using the expression #prompt('selection','token','[Sales]')#
I created a radio-prompt selection with static choices for Sales and Orders.
In doing so, I  was able to achieve Req1 and Req2.

Please advise if there is a way to achieve Req 3 for the above scenario using conditional styles


Regards,
Sameena

[sdf]

ideally, you can try to set the radio prompt to optional. But since it's a prompt and you are using  macro it needs a parameter to pass.
can you change the prompt to be a dropdown selection? then instead of haveing "none" or "both" you can have another static choice as "selection" which will be the default selection. This will act as title/label for the prompt.

just a suggestion.