sum in table

[#1]

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

[lironbaram]

you should build a table

with period as the dimension and sum(Number) as the expression

[cfz]

Hi Luca,

The easiest way is to use a pivot table and do a simple sum as in the example. Otherwise in order to be able to help you I would nee to know how the table needs to look like, that, is with dimensions must be present and where in the table the different results 6, 4, 50 need to appear. A screenshot of the desired table would be great to avoid misunderstanding.

Kind regards

Carlos

[#4]

Thanks Liron.

I'va already build a table, but doesn't work. The field Type does not allow a simple sum (Number)..

[sujeetsingh]

See this sample