Hiding Row in Webi Report

[Former Member]

hi,

How to Hide the rows in a webi report?

Sample output --

Login 01/02/2010/10:45:50

Modified Record 01/02/2010 10:45:50

Modified Record 01/02/2010 10:46:50

Delete Record 01/02/2010 10:55:50

Delete Record 01/02/2010 10:56:50

Modified Record 01/02/2010 10:58:50

Delete Record 01/02/2010 10:59:50

*Required Output*

Login 01/02/2010/10:45:50

Modified Record 01/02/2010 10:45:50

Delete Record 01/02/2010 10:55:50

Modified Record 01/02/2010 10:58:50

Delete Record 01/02/2010 10:59:50

I used a condition in a variable =if(Previous([Activity])=[Activity];0;1) and placing inside report.

But when i am giving block filter i am getting only the distinct activity and Time not as required output.

Please help...

[hansen_chen]

The approch should work, make sure to use formula on each column, like

=If([State]=Previous([State]);"";Min([City]))

[Former Member]

Hi Sathish,

I am not 100% clear on what you are trying to do but you should be able to use a max() or min() function on the datetime, since it appears you are trying to get the first one (in which case you should use min()).

Does that help?

Thanks