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 | - |
