Skip to Content
0

how to hide a row in webi if value is 0?

May 01, 2017 at 08:17 PM

104

avatar image
Former Member

Lets take my eg , below is my data on the report. each measure value is coming from different object .

eg :

sales_id country value

1 Ind 0

2 UK 22

3 UK 45

I want to hide the row of table if value is 0 (i.e 1st row) and table should restructure to :

sales_id country value

2 UK 22

3 UK 45

Please help , your help should be appreciated .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

AMIT KUMAR
May 01, 2017 at 08:55 PM
0

have you tried to apply filter on column4 where not equal to 0?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 01, 2017 at 08:42 PM
0

cond1.png

Hi Amit,

Please see the attached screenshot for my prob.

1. I am having multiple 0 in my table , So I can not use that option that you mentioned.

2. I need to hide the row if data in column4 is 0 (means on the basis of column 4 I need to hide the data and table should restructure as in the eg)

3. data is coming from indivisual object .


cond1.png (9.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
May 01, 2017 at 08:25 PM
0

right click on the table->format table->uncheck highlighted check boxes.

this will work when your value object is as measure type.


untitled.png (29.5 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

Please see the attached screenshot for my prob.

1. I am having multiple 0 in my table , So I can not use that option that you mentioned.

2. I need to hide the row if data in column4 is 0 (means on the basis of column 4 I need to hide the data and table should restructure as in the eg)

3. data is coming from indivisual object .cond1.png

cond1.png (9.7 kB)
0
avatar image
Former Member May 01, 2017 at 09:02 PM
0

Hi,

You can follow Amit's suggestion if it works for you.Other way to resolve this issue is you can check below solution.

https://archive.sap.com/discussions/thread/1879196

https://michaelwelter.wordpress.com/2010/12/16/suppress-rows-with-zero-value/

Thanks,

Sasi

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Sasi ,

Value is become null but when unchecking show rows with empty value , it is not hiding the row.

0