Forum Discussion

rafieya's avatar
rafieya
Regular Visitor
8 years ago

Cumulative total from multiple column

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

 

Need Help

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    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,