Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 col...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!