Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expects,
I need to calculate the no of customers that should available in all selected date. I have attached the sample data. any one can help me to do the task.
Thanks
Hi,
try this in Text Box
=Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))
Regards,
Antonio
Hi,
Try like below
count(distinct Customers)
Hi Devarasu,
Thanks for you reply, This is not my output, i should count the customers who all available in all dates.
Can you share your expected output for the given data,.tks
Hi,
try this in Text Box
=Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))
Regards,
Antonio
if i select the following dates
2-20-2017 |
2-20-2017 |
2-23-2017 |
2-23-2017 |
3-20-2017 |
3-20-2017 |
3-20-2017 |
3-20-2017 |
3-15-2017 |
3-15-2017 |
my output should be
Because in my data customer "A" is available in all dates
if i select the following dates,
3-15-2017 |
6-20-2017 |
my output should be
Because in my data customer "A" and "B" is available in selected two dates
Thanks
hi Antonio,
Thank you so much, yes this is my output. but one more step i have to do,
I have to plot this value in the date.
is it possible??
I have attached my data,
Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))
from above expression i am getting my output
i need to show the result in following way,
by your expression i am getting the result "1" value only at the 1st date the result "1" should appear in all selected date.
Hi,
Try this
=Sum(TOTAL Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))
Regards,
Antonio