How to get data into adjacent columns in Impromptu?? 1

[prince18]

Hi all,
I am working a report where I need to retrieve data based on a condition into adjacent columns varying on the condition.
Suppose if I have numbers in a column in a table, I want to put 1-100 into coln A and 100-200 into coln B in the report.
Is there any possibility I can do that?
How?
Ayone Please help me in this regard!!

Thanks in Advance,
G

 

[plevey]

Add two calculations:

Small: If(column <= 100) then (column) else null
Big: If(column > 100) then (column) else null

and use these in your report



If fishing was easy it would be called catching