Problem with Aggr & Set Analysis

[ecolomer]

Hi,

I need to obtain in a  table with (Ventas) Sales >0 in the Actual Year and the same for the last Year and but my expression don't work.

• count({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} distinct Cliente)
• Sum(if(Aggr(Sum({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} imVentaTAM), Cliente)>0, 1,0) )

the number of Customer

[sunny_talwar]

What are the expected numbers here?

[ecolomer]

Hi Sunny T,

Attached I send a excel file with the list customers and marked error in column

[ecolomer]

For Nº Clientes 2016 = 111 (no 120) and for Nº Clientes 2015 = 119 (is OK)

This data por a selected line (ALB  ALBACETE

Attached you have an excel with detailed data

[Anil_Babu_Samineni]

Can you please post sample Application?

[ecolomer]

In the original post is a qv file

[antoniotiman · Accepted solution]

Hi Enrique,

In Your Doc I tried

count({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'},Cliente={"=Sum({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} imVentaTAM) > 0"}>} distinct Cliente)

The result is 111

Regards,

Antonio