Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
You don't need use AGGR function.
Only with Sum(paletas) you have the total by day if you put date in dimensions
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.
See this:
The qv file