This content has been marked as final. Show 2 replies
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?