How to find count of customers whose sum of sales of one week is greater than 10000 in text object

[shivani_singhal]

Hi,

I have sales transaction table. And I want to find the count of customers whose sale is greater than 10000 in a week based on selection in Text Object or KPI.

[tresesco]

If you are selecting a week then you may try like:

=Count( Distinct {<Customer={"=Sum(Sales)>10000"}>} Customer)