Aggr Function

Tue, 03 Jul 2012 13:22:14 GMT

Hi Guys.

I have a table with Dates, amount of sales and total of money for that sales.

I want to add an Aggr funtion grouping by Year and Month. I use that function as you see in the header of the following table.

I get "-" for all days of the month unless the first day. I want the same value repeted for all the days. I placed the table as I need below.

I really appretiate your help.

Thanks

This is what I need!

Date	n° Sales	Sum(Budget)	Aggr(sum(SolImpSolicit),Year,Month)
01/01/2012	3	807	29.199.904
02/01/2012	957	3.584.905	29.199.904
03/01/2012	1176	4.306.302	29.199.904
04/01/2012	1404	4.689.416	29.199.904
05/01/2012	1905	6.323.552	29.199.904
06/01/2012	288	612.333	29.199.904
07/01/2012	890	3.160.001	29.199.904
08/01/2012	162	555.044	29.199.904
09/01/2012	1521	5.967.543	29.199.904
01/02/2012	638	3.740.546	35.704.289
02/02/2012	656	3.723.210	35.704.289
03/02/2012	791	4.255.689	35.704.289
04/02/2012	516	2.650.510	35.704.289
05/02/2012	70	320.220	35.704.289
06/02/2012	963	5.336.331	35.704.289
07/02/2012	907	4.830.365	35.704.289
08/02/2012	848	4.780.046	35.704.289
09/02/2012	1024	6.067.371	35.704.289
01/03/2012	357	3.834.085	37.977.909
02/03/2012	393	4.304.078	37.977.909
03/03/2012	244	2.540.731	37.977.909
04/03/2012	37	241.446	37.977.909
05/03/2012	426	4.523.179	37.977.909
06/03/2012	368	4.299.208	37.977.909
07/03/2012	429	5.814.514	37.977.909
08/03/2012	469	5.743.115	37.977.909
09/03/2012	528	6.677.554	37.977.909

This is what I get!

Fecha de Emisión	Colocación Casos	Monto colocación	Aggr(sum({<%Fecha=>}SolImpSolicit),Año,Mes)
01/01/2012	3	807	29.199.904
02/01/2012	957	3.584.905	-
03/01/2012	1176	4.306.302	-
04/01/2012	1404	4.689.416	-
05/01/2012	1905	6.323.552	-
06/01/2012	288	612.333	-
07/01/2012	890	3.160.001	-
08/01/2012	162	555.044	-
09/01/2012	1521	5.967.543	-
01/02/2012	638	3.740.546	35.704.289
02/02/2012	656	3.723.210	-
03/02/2012	791	4.255.689	-
04/02/2012	516	2.650.510	-
05/02/2012	70	320.220	-
06/02/2012	963	5.336.331	-
07/02/2012	907	4.830.365	-
08/02/2012	848	4.780.046	-
09/02/2012	1024	6.067.371	-
01/03/2012	357	3.834.085	37.977.909
02/03/2012	393	4.304.078	-
03/03/2012	244	2.540.731	-
04/03/2012	37	241.446	-
05/03/2012	426	4.523.179	-
06/03/2012	368	4.299.208	-
07/03/2012	429	5.814.514	-
08/03/2012	469	5.743.115	-
09/03/2012	528	6.677.554	-

Re: Aggr Function

swuehl — Tue, 03 Jul 2012 13:39:05 GMT

Try using a NODISTINCT qualifier in your aggr() function:

Aggr( NODISTINCT sum({<%Fecha=>}SolImpSolicit),Año,Mes)

Tue, 03 Jul 2012 13:46:02 GMT

You ROCK!

I didn't know that!

Thanks!