ACCUMULATE CALCULATION

Question

&nbsp;I have de following matrix with 2 Orders (A and B) with 2 lines of material per lineHOW TO CREATE THE "Total of Order" COLUMN THAT HAS IN EACH LINE THE TOTAL VALUE OF THE ORDER THAT IS EQUAL TO THE SUM OF THE PARTIAL VALUES OF EACH LINE OF THE ORDER&nbsp;Order&nbsp; &nbsp; lines&nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp; &nbsp; &nbsp; Total of OrderA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20

amitchandak · Accepted Answer

Anonymous ,
A new column
&nbsp;
Sumx(filter(table, [Order] = earlier([Order])),[Value])
&nbsp;
&nbsp;
a new measure&nbsp;
&nbsp;
Sumx(filter(allselected(table), [Order] = max([Order])),[Value])
&nbsp;
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

Forum Discussion

ACCUMULATE CALCULATION

2 Replies

Related content

Rolling accumulation

Rolling accumulation

Accumulated average

calculate the accumulated

calculate accumulations