Hello everyone,
I have a dataset like this :
ID |
TAX |
SubTotal |
1 |
10 |
2 |
1 |
10 |
2 |
1 |
10 |
2 |
2 |
5 |
3 |
I want a calculated field that can return for each distinct ID the sum of subTotal and Tax.
So I'll here get for ID = 1 a result of 12 and NOT 36.
Thank you all !