How to achieve a total count WITH weekday schedule

Hi,

I have a situation in which I am trying to display various items produced on multiple factory lines (in different regions) by day of the week.

For instance, in my example, we see that Factory1 makes four different types of items on Production Line 10 but it makes these four different items in batches on different days of the week. In my table I can see HOW MANY batches of each item I do per week but I can't figure out how to display on WHICH WEEKDAYS I do those batches. I am currently just writing a note to the side (ex. "M,T,W").

Is there a way to use weekday columns with "x" or binary "1" or "0" to easily display a schedule like this by day of the week? For instance, it would be great to see how many TOTAL RACKS I will do on Monday without doing a SUM off to the side and manually selecting each item that I know falls on a Monday.

Thank you!

Welcome to the forum.

I think you need to mock up the sort of thing you are hoping for manually - a visual will help to clarify your request.

In your excel file you ask:

"How could I incorporate a weekly schedule coponent to this? DOES NOT NECESSARILY NEED TO BE PART OF THIS PIVOT TABLE"

Add an date in your data e.g. in column P.

After that you can use that information to analyse the data.

To get the Example results from the table of data at the top of the sheet paste the following into cell E41 and then drag the fill handle over and down:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.