Cumulative total from multiple column

[rafieya]

Hi all,

I'm stuck with this and i can't find a solution on the spider. I have 3 tables in  each one there is a quantity (forecating production, receipt goods, inventory) and I need to forecast our inventory with the last inventory entree. so the simple formula is :

Initial inventory + receipt - forcasting production

I create a measure to find the last inventory

Stock initial:=CALCULATE(SUM(Stock[Quantité]);LASTDATE(Stock[Date]))

the another one to forecast the inventory

projection:=Stock[Stock initial]+[Total réception]-[Total prevision]

and this what i got in the pivot table

in the header row those number are week number and number of woking days, in the "projection" line I want a cumulative forecast 

any help Please

any Help please

[v-sihou-msft]

@rafieya

In this scenario, you want to calculate the cumulative total for that "forecast". Since your "forecast" value is from a measure, to apply calculation on these values, you have to summarize that measure into a column. So you may create a calculated table, then calculate this "cumulative forecast".

Regards,

[rafieya]

Thank you @v-sihou-msft

so if I understand this how my schem must look :