Sum of rows

[#1]

Hi All

I have this data:

Hi All

I have this data:

in a table.I want to set an expression to have this result:

A -> 6 (sum of all Number with Period=A)

C -> 4 (sum of all Number with Period=C)

B -> 50 (sum of all Number with Period=B)

and so on..

How can I set the sum() ? Aggr ( sum (Distinct Number), Period) doesn't work..

Thanks

luca

in a table.I want to set an expression to have this result:

A -> 6 (sum of all Number with Period=A)

C -> 4 (sum of all Number with Period=C)

B -> 50 (sum of all Number with Period=B)

and so on..

How can I set the sum() ? sum (Number) or Aggr ( sum (Distinct Number), Period) doesn't work..

Thanks

luca

Messaggio modificato da luca

[nizamsha]

Look at The Attachment