Aggr but not showing all year´s registers

[#1]

Hi everybody,

I´ve used the aggr function for having only one day register per day and to avoid repeats of the same days.

Aggr(sum([4.TRANSPORTES-EXPEDICIONES.PALETAS BOTES]),[4.TRANSPORTES-EXPEDICIONES.Día])

But when I try to get all the data in a table or draft It only shows me the days reffered to one of the year instead giving me a complete list of values with year 2014 and 2015.

Do anyone know how to aggregate a list of many values in the same day with all the values in the same table?

Attached you find the example I´m trying to develope.

Thanks and regards.

Urdru.

[ecolomer]

Creo que puedo escribirte en español ...

No tienes que utilizar l  función aggr, basta con que pongas Sum()

Pruebalo y me dices-

Saludos,

Enrique Colomer

[ecolomer]

You don't need use AGGR function.

Only with Sum(paletas) you have the total by day if you put date in dimensions

[#4]

Thanks Enrique.

But it still not working... If I use only the sum for  the example I get the repetition of each row not the group of the sum of the values.

And if I use the Aggr function I get only one year per table and not the whole serie.

Regards.

[ecolomer]

See this:

[ecolomer]

The qv file