Examples of using Conditions in Calculations

If you want to know how to write Conditions in Tableau, go through the this link.



EX: List of the STATES which sales are more than 10K in 2012.

Steps:
1) Create a Calculated Field like below.
Name: States - Sales>10K in 2012
Syntax:
if attr(year( [Order Date]))= 2012 and sum([Sales])>10000 then sum([Sales] ) end

2) Drag the [State or Province],  [Order Date] on to Rows shelf, [States - Sales>10K in 2012] onto Text Marks.

3) Drag [States - Sales>10K in 2012]into filters shelf, then select "Special" option then select "Non-null values".