1 Reply Latest reply on Aug 25, 2014 11:57 AM by Joshua Kennedy

    Calculated Field  If Dimension Total < x Then Exclude Dimension

    Richard Dunn

      Hello, I am very new to Tableau! I have a Live table where I pull in widgets sold. If the sum of Widgets sold is < 2 then I want to exclude it from my totals calculation.


      I have used this expression TOTAL(SUM([Number of Records]) >=2) in the it hides the values under each week, but still shows up a 1 in the totals.  I want to exclude these until their Number >=2.


      Thank you!! Any help would be appreciated.


      Sincerely


      Rich