Can you try and drop sum( sold amt USD) in filter and then select 0 or NULL to get the desired ouput.
Lets assume your data is like this
As per your requirement either number or null value should be excluded from the measures FY15 and FY16.
If so then the highlighted records will be eliminated from the data set.
create a calc field as per the attached screen shot. Drag this calc field in filter shelf then select only "T".
I hope this will help you.
Feel free to ask if you have any query.
is there a way to filter out the division, if sales of any of the month is 0 or NULL?
that means I only want to use division that all months sales is not 0 or NULL for further calculation
ZN function is designed exclusively by tableau to check Z- Zero or N-Null values and yield results based on the content included inside the function.