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