Restrict dimension based on calculated value

[#1]

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!

[whiteline · Accepted solution]

It's not so easy.

You have to explain to QV how this expression should be calculated:

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

[#3]

Dear Elie,

Please see the attached QV File.

Regards

Mhatim