Add the amount of customers who earned less than 300

[#1]

Hello Gentlemen,

how can I do to add how I faturei a value less than 300 reais.

dimension Month

with this I will know how many customers bought me less than 300 reais a month.

example:

Dimension

Month billed customers who bought

January 30 1,000.00

February 20 2,000.00

March 5,000.00 45

what I want is:

Month Customers who bought below 300

January 5

February 8

March 12

How can I make this measure?

[sunny_talwar · Accepted solution]

May be like this:

Sum(Aggr(If(Sum(Value) <= 300, 1, 0), Customer, Month))