UNIQUE CUSTOMERS EACH MONT

AppSheet AppSheet Q&A
1

Hi, I need to count all the customers we invoiced each month
I use “Count”, and i use “Select”, but, it counts all the registers, not only the unique clients for each month. Help please. Thanks

COUNT(UNIQUE(REPORTE FACTURACION[CLIENTE UNICO MES]))

This formula gives me all the customers, but not for each month.

Thanks

2

Hey man,

try something like that:

COUNT(UNIQUE(
  SELECT(REPORTE FACTURACION[CLIENTE], 
    AND(
      MONTH([FECHA]) = MONTH(TODAY()),
      YEAR([FECHA]) = YEAR(TODAY())
    )
  )
))
3

Thanks. It worked perfect

1 Like