Not applicable
2016-09-30
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add the amount of customers who earned less than 300
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?
221 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2016-09-30
10:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
Sum(Aggr(If(Sum(Value) <= 300, 1, 0), Customer, Month))
184 Views
1 Reply
sunny_talwar
MVP
2016-09-30
10:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
Sum(Aggr(If(Sum(Value) <= 300, 1, 0), Customer, Month))
185 Views