Splitting One query item in two data item

[BiliBoy]

Hi

I have one query item which has a flag.  This Flag produce Y or N value. How can i convert 'Y' in first data item and 'N' in second data item. I do not want use  detail filter  in order to achieve this.  Any expert willing to share their wealth of knowledge  for me.

[Lynn]

For the Y data item try this:

Code Select Expand


case [YourFlagItem] when 'Y' then 'Y' else null end


For the N data item try this:

Code Select Expand


case [YourFlagItem] when 'N' then 'N' else null end