New customer

[spividori]

Hi.

I want to know how many new customers bought in the selected period.

In the attached example, in the period 09/2013 I have customers A, G and H, I should have G and H, because A has already bought.

Regards.

[luciancotea · Accepted solution]

=Sum({1< >} aggr( if((min({1< >} Total <Cliente> Fecha)) = min(Fecha),1,0), Cliente))

[rajni_batra]

hi lucian will you plz expalin what {1< >}  does ?

I have never used this thing,,

Thanks,

[luciancotea]

See help on Set Analysis.

[spividori]

Hi Lucian.

You can see it in my real data works poorly.

For example, I select May-2013 and sees as follows:

Attached is an example with my real data. Regards.

[spividori]

HI.

Already solved, thank you very much.

Sum({1< >} aggr( if((min({1< >} Total <Vta_Cli> Vta_Fecha)) = min(Vta_Fecha),1,0), Vta_año, Vta_mes, Vta_Cli))

Regards.

[jose123456]

hola necesito hacer esto para qilkview

la idea es presionae año 2013  mes  enero y el  ptro mes mayor al siguiente

SELECT distinct NOMBRE

  FROM [FRONT].[dbo].[131 AUDITORIA FONDO]

where  fecha >='2013-01-01' and  fecha <='2013-01-31'

    and NOMBRE not in(select distinct NOMBRE  FROM [FRONT].[dbo].[131 AUDITORIA FONDO] where

       FECHA <='2012-12-31')