suppress dimension when expression is null

[#1]

Hi!

I've got a table with "StartTime" as dimension and "if(below(startTime)>$(Time),SignalDescription,null()) as expression.

the outout is like:

02/12/2011 15:31:13   

02/12/2011 15:32:02   

02/12/2011 15:32:34   

02/12/2011 15:33:00   

02/12/2011 15:33:07   

02/12/2011 15:33:47    SignalDescr1

02/12/2011 15:34:01    SignalDescr2

02/12/2011 15:34:24   

02/12/2011 15:35:16   

02/12/2011 15:36:10   

02/12/2011 15:36:33   

02/12/2011 15:39:02   

02/12/2011 15:39:55   

02/12/2011 15:40:08    SignalDescr3

02/12/2011 15:40:16    SignalDescr4

but i want:

02/12/2011 15:33:47    SignalDescr1

02/12/2011 15:34:01    SignalDescr2

02/12/2011 15:40:08    SignalDescr3

02/12/2011 15:40:16    SignalDescr4

Have you got any suggestions?

Regards

-Davide

[#2]

Simply do what you have written in your heading:

DIM1: Date
DIM2: =if(len(trim(Value))>0, Time)

EXP1: Value

plus:
Suppress when  value is null: on

Message was edited by: maha1985

[#3]

with above o below function i must use only 1 dimension