Skip to Content

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

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 01, 2017 at 08:55 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 01, 2017 at 08:42 PM

    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 .

    Add comment
    10|10000 characters needed characters exceeded

  • May 01, 2017 at 08:25 PM

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

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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)
  • avatar image
    Former Member
    May 01, 2017 at 09:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded