Aggr function

[marco_puccetti]

Hello can you tell me how does the aggr function works?

in this case aggr(sum(Sales), Country)

what is generated?

Thanks

Marco

[sasiparupudi1]

Hi

aggr(sum(Valori),Prodotto)

the above statement gives a total sum of valorie values per each Prodotto in your table.

I think it will make more sense if had you table data defined like this

LOAD * Inline

[

Prodotto,Valori

PIPPO,1

PIPPO,10

PIPPO,100

PLUTO,2

PLUTO,20

PLUTO,200

TOPOLINO,3

TOPOLINO,30

TOPOLINO,300

];

[marco_puccetti]

In this case it works.

So in the aggregation is showed only the expression values (first argument).

Thanks

Marco

[marco_puccetti]

How is it created the Aggragate table?

Thanks

Marco

[sasiparupudi1 · Accepted solution]

Hi

Please have a look at the attachement.

Basically selected the dimension Prodotto and an expression columns called aggrgate which has the formula Aggr(Sum(Valori),Prodotto)

Sasi

[marco_puccetti]

OK you have to use the prodotto as dimension and this statement to get the data aggr(sum(Valori),Prodotto).

Thanks

Marco