on 09-17-2010 11:35 AM
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...
The approch should work, make sure to use formula on each column, like
=If([State]=Previous([State]);"";Min([City]))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.