0 Replies Latest reply on Aug 14, 2013 7:47 AM by Swee Chua

    filtering on a table calculation

    Swee Chua

      Hi,

      I am doing some sales analysis and would like to show customers with negative sales growth, for example, below -50% (ie, a 50% drop in sales month to month). I am able to use the table calculation features in Tableau to calculate the month-to-month change in sales by customer.

       

      However, I am stuck in applying a filter on customers where that percent difference in sales is lower than a certain threshold. I saw a previous tread (use table calculation in a calculation) and tried to apply the same principle. But what that does is to hide the sales change outside of the criteria while the list of customers are unchanged (ie, all customer still show in the list but some have blanks next to them). - see example attached.

      I would appreciate help in filtering out totally customers who are outside the range.

       

      Thanks,

      Swee