SetAnalisis

[#1]

I have to bring all businesses in the current year that were open last year and businesses that the month previous year did not sell to zero.

Example:

Previous Year( 2009 😞

Month 01 02 03 04 05 06 07 08 09 10 11 12

Sale0 0 0 50 100 100 120 120 101 50 60 80

Current Year( 2010 😞

Month 01 02 03 04 05 06 07 08 09 10 11 12

Sale10 100 110 50 100 100 120 120 101 50 60 80

Show:

Month 01 02 03 04 05 06 07 08 09 10 11 12

Sale0 0 0 50 100 100 120 120 101 50 60 80

I use this set analysis and shows me current stores that were open last year, but I have values in the months that no sales the previous year:

sum({$<negocio= p({$<año={"$(=YEAR(addmonths(max(fecha),-12)))"}>} negocio) >} ventas)