2 Replies Latest reply: Sep 14, 2012 6:05 AM by mhatim2012 RSS

    Restrict dimension based on calculated value

      I am trying to create a table which would show me the top 20 customers based on sales who have made at least 5 purchases in a Straight Table. I have added a condition to the table loading that states:

       

      Count(Sales.id) > 5

       

      which stops the entire table from loading data if the total number of sales is less than 5. However, what I want is to stop the loading of a particular row in the table if the total number of sales is less than 5. I tried putting in the following expression into the dimension for the table, but I get an "Error in calculated dimension":

       

      if(Count(Sales.id) > 5, Customer.name)

       

      How do I go about doing this?

       

      Thanks!