Regarding Line Charts

Hello Guys,

I have a data table which is having different columns. The main columns i want to use in the desired Line Chart are Created Shift and Ends Shift. For example an item can be created by any of the shift can also be closed by any shift. I want to represent the cummulative data in a line char for items created by per shift and also the the cummulative data for items closed by the shifts.

If i will choose "SHIFT A" from the filter, then the line chart must represent the data in the Line Chart:

1. Line 1:- Cummulative items created by the shift A.

2. Line 2:- Cummulative items Ended by the shift A.

As of now, the problem i am facing is that if i am trying to represent the data as i resire to, then the data is not correct because both the columns are in the same table. Due to which the filter doesn't works.

Please help me with the solution the big FAM.

Thanks in advance.