Aggregation sum over a particular dimension in a table chart

[ruma_barman]

Hi All,

My requirement is I need to show the aggregate sum against a particular dimension.

Here for e.g if there are 2 document numbers against particular asset number the value of the asset i.e the output should be distinct sum of it alongwith aggregation over  documentno as below:

Input :

DocumentNo,AssetNo,Value

D1,A1,11

D1,A1,11

D2,A2,22

D2,A2,22

D3,A2,33

Output:

DocumentNo,AssetNo,Value

D1,A1,11

D2,A2,55

D3,A2,55

Thanks in advance,

Ruma

[tresesco · Accepted solution]

Try:

Sum( total <AssetNo> DISTINCT Value)