Forum Discussion
Accumulated column
Hi guys I need your help,
I work in an industrial company wich has 4 production lines.
I´ve already had three columns: Date, Line, Units produced (each day for each line)
I need an extra column with the accumulative units from Monday to Sunday for each line.
Basically:
-Line 1:
Monday: X units
Tuesday: Y + X units
Wednesday: Z + Y + X units
....
And the same every weeek for EACH line.
Do you know what´s the way to do it, or what formula can I use?
Thank you soo much!!
4 Replies
- amitchandak
Super User
Anonymous , refer if My WTD blog can help you
It do have pbix attached
Thank you so much amitchandak, I tried to follow your steps but unfortunately I didn´t get my result. I think the accumulated I need is a little bit more complicated because we need to filter by line too... Could you please have a look the photos I´ve just upload to replied to Jimmy?
Thank you soo much!
v-yuta-msftCommunity Support
Anonymous ,
The info you give is not complete, could you please share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
Hello Jimmy,
Basically I have four important columns: Day, Line, teoric units, and Real manufactured units:
I need TWO EXTRA columns with the accumulated teoric and real units per WEEK and LINE.
The final objetive is obtain something like this:
Here you can see we have filtered by week and in the second tablet we need to see:
- On Monday: Monday Teoric and Real Units
- On Tuesday: Monday + Tuesday Teoric and Real Units
- On Wednesday: Monday + Tuesday + Wedenesday Teorica nd Real Units
....
Do you think is it possible? I´m spending so much time to get this accumulated columns but I can´t find the way to obtain them...
Thank you so much!
