Aggr

[#1]

hi,

I did a formula =aggr(sum(Metric),Country, Month) and I would like display it by product.

do you know why, it's working for the first product, but I cannot repeat values for all of them?

thanks,

Eva

[Anonymous]

Great discussion! I am facing the same problem.

When using =aggr( NODISTINCT sum(Metric),Dim1, Dim2) how to display the total in a straight table?

When using Expression Total it will give us the sum of the nodistinct what is wrong.

So how can it be achieved to get the aggregation values repeated (nodistinct) inside the table, and a (distinct) total sum above?

[saray_JD]

Hi

you can use Total <Group by Fields> in sum function instead of Aggr too.

like this :

=SUM(Total<Country,Month> Metric)

Have good Day

Saray