
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to retrieve the number of lost customer in actual month
Hi everybody ,
I need your help :
I have sales revenues on customers in August 2017.
Among these clients active in August 2017, I would like to have the number of customers who are at 0 euros on the month of August 2018
How can I have this information please ( using Text box not chart )
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try like this
=Count({<Customer=P({<Month={'Aug 2017'}>})-P({<Month={'Aug 2018'}>})>} Distinct Customer)
&Chr(10)&
Concat({<Customer=P({<Month={'Aug 2017'}>})-P({<Month={'Aug 2018'}>})>} Distinct Customer,'-')
Regards,
Antonio


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can use Set Analysis, for example:
Count({<Month={'August'}, Revenue={0}>} Distinct Customer)
I don't know your data model exactly, but this more or less can work.
Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
like this?
=Count({<Customers ={"=sum(Revenue)=0"}>}distinct Customers)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi , thanks for your time.
But this not what I expect , indeed : this return customer with revenue = 0 in August.
I need to retrun the number of customer who were actif in last year and not now :
For example :
In august 2017
Customer ID , Revenue
Customer1 , 10 $
Customer2 , 20 $
Customer3 , 30 $
In August 2018
Customer1 , 20$
my request must return ==> 2 ( 2 lost customers )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
Count({<Customers =p({1<Customers={"=sum({1<Year={'$(=max(Year)-1)'}>}Revenue)>0"}>}Customers)>}distinct Customers)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try like this
=Count({<Customer=P({<Month={'Aug 2017'}>})-P({<Month={'Aug 2018'}>})>} Distinct Customer)
&Chr(10)&
Concat({<Customer=P({<Month={'Aug 2017'}>})-P({<Month={'Aug 2018'}>})>} Distinct Customer,'-')
Regards,
Antonio

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have same kind of question but little tricky that I have to find no of lost customer in current year compare to previous years.
Thanks in adavance
