help with filters in sheets

[kalavala_vijayk]

Hi All,

Could any one help me on this issue, how can i apply filter for this scenario.

Along with count i have List of customers who have purchased.

Date	Count
15-Apr-20	150
14-Apr-20	233
13-Apr-20	645
12-Apr-20	450
11-Apr-20	225
10-Apr-20	4454
9-Apr-20	12
8-Apr-20	55
7-Apr-20	45

 So, i need to display only if the count of customers with >=500 , with list of dates and counts in the sheet and also with the names of the customers who have purchased more than 500 in the same sheet.

Could someone help

Thanks,

Vijay

[Wlad_Masi]

Is somehow the name of the customer linked to count and date?

I would suspect yes.
In this case create a table with
Customer name and Date as dimensions and count as measure, using an if statement:
If(count of X >=500, count of x)