Display column value based on the prompt value DMR

[Shailaja0520]

Hi,
I have requirement. Its a DMR.

I have a  multiselect prompt Suppose Prompt_p1  with values  A,B,C,D.

I need to display the data in a column for e.g Column 1 if  Prompt_p1 contains only 'A' otherwise nothing in that Column.

[Deep750]

Isn't it possible to add a layout calculation in the column?

[Rahul Ganguli]

You can achieve this using COnditional Styles and Style Variables.

Regards,
Rahul

[Lynn]

I think you could also do it by creating a data item in the query. This would force the prompt to be required, so don't go with this approach if your prompt is optional.

Code Select Expand


case ?Prompt_p1?
when 'A' then 'A'
else null
end