Sum all value in group

[phongnnguyen]

Dear guys,

I have a problem with my set analysis. I want to sum group all value like below table:

Account	Client	Value
A1	A1	100
A2	A1	200
A3	A1	300
B1	B1	400

this is my expected result:

Account	Value
A1	600
A2	600
A3	600
B1	400

My expression is:

aggr(sum(value),client)

But it's not work.

Thanks for help !

[lironbaram · Accepted solution]

hi

this should answer your need sum(aggr(nodistinct sum([Value]),Client))

[agastya]

[phongnnguyen]

Thanks for your help. but it is not work too.

[phongnnguyen]

Thanks for your consider but I dont understand what's your mean.

[balabhaskarqlik]

May be these:

rangesum(above(TOTAL sum(value), 0, rowno(TOTAL)))

rangesum(above(Value, 0, rowno()))

[lironbaram]

hi

what do you mean it doesn't work

this was tested on the demo data and works ,

do you have additional dimensions on your table?

[phongnnguyen]

Hi Liron Baram,

Sorry about this information, i just have tested your code, and it works with me.

Thanks for your help so much