4 Replies Latest reply on Jun 7, 2016 7:58 AM by Lucy Jones

# Please can you help me, I need to hide the rows I have which show '0'. I have negative numbers as well as positive so I cannot just filter to show everything greater than 0

Please can you help me, I need to hide the rows I have which show '0'. I have negative numbers as well as positive so I cannot just filter to show everything greater than 0. Is there a way of changing the zero's to nulls and then hiding the nulls?

Any help would be greatly appreciated.

Thank you

Lucy

• ###### 1. Re: Please can you help me, I need to hide the rows I have which show '0'. I have negative numbers as well as positive so I cannot just filter to show everything greater than 0

hi Lucy,

I'm not sure if your zero's are row level (i.e. the base data) or are after you've performed an aggregation eg. SUM([Sales])...I'm assuming the former (let me know if it's the latter!)

[Remove Zero Rows Filter]

[MyValue] <> 0

Add this to the filter shelf, and select 'True'

Hope that helps.

• ###### 2. Re: Please can you help me, I need to hide the rows I have which show '0'. I have negative numbers as well as positive so I cannot just filter to show everything greater than 0

Hi Lucy,

You can try to create a filter based on a calculated field:

SUM([Sales])>0 OR  SUM([Sales])<0

Place the calculated field into the mark card and set that on true and it should work.

Hope this helps,

• ###### 3. Re: Please can you help me, I need to hide the rows I have which show '0'. I have negative numbers as well as positive so I cannot just filter to show everything greater than 0

Thank you so much, this has worked perfectly

• ###### 4. Re: Please can you help me, I need to hide the rows I have which show '0'. I have negative numbers as well as positive so I cannot just filter to show everything greater than 0

Thank you so much, this answer also works perfectly