Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
hi
this should answer your need sum(aggr(nodistinct sum([Value]),Client))
hi
this should answer your need sum(aggr(nodistinct sum([Value]),Client))
Thanks for your help. but it is not work too.
Thanks for your consider but I dont understand what's your mean.
May be these:
rangesum(above(TOTAL sum(value), 0, rowno(TOTAL)))
rangesum(above(Value, 0, rowno()))
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?
Hi Liron Baram,
Sorry about this information, i just have tested your code, and it works with me.
Thanks for your help so much