Showing Only Zero or Null Values based on a Variable

[samir_bihari]

Hi Experts,

I have come across a situation where I need to display only the zero values if a variable is on. Below is the table data and scenario:

SKU	Department	Month	Sales Quantity
1	Auto	Jan 2017	4
2	Auto	Jan 2017	5
3	Manual	Jan 2017	0
4	Manual	Feb 2017	0
5	Manual	Feb 2017	0
6	Semi	Feb 2017
7	Semi	Feb 2017

I have a variable called NoSales. What I want is if NoSales = 1 , then the table should show only SKU no 3,4,5,6,7 i.e where quantity is 0 or no value.

how I can achieve this?

[Anonymous]

if(not sum(Sales Quantity) > 0,' ',null())

+ activate supress zero values in chart.