How to retrieve the number of lost customer in actual month

[#1]

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 )

[jmvilaplanap]

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

[Kushal_Chawda]

like this?

=Count({<Customers ={"=sum(Revenue)=0"}>}distinct Customers)

[#4]

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 )

[Kushal_Chawda]

try this

Count({<Customers =p({1<Customers={"=sum({1<Year={'$(=max(Year)-1)'}>}Revenue)>0"}>}Customers)>}distinct Customers)

[antoniotiman · Accepted solution]

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

[Kvr]

Hi All,

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