I am looking for condition where data need to be filtered by zero (only for November 2015)
Refer below image where brands wise sales is available for month's
My desired output will not have brands whose sales is greater than 0 in the month of November 2015.
1, 3,6,7,8,9,10 and etc should be excluded. 2,4,5,13 etc should be displayed as output.
Please refer the below image for the same. (I tried doing this in excel and its giving me desired result)
Please refer to the attached tableau workbook and attached excel (contains desired result).
Any help is appreciated.
Thanks in Advance,
In your Brands filter add the following condition:
NOT(ZN(SUM(IF [Month] = #2015-11-01# THEN [Net Sales] END))>0)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...