I am trying to create a pivot table to track waste for certain machines.
I can create a pivot table that has "date" as the row titles and the reasons for the waste as the column titles.
I will attach a file as an example Waste Management.xlsx
However, there are multiple machines I would like to track. The above shows the tracking for one machine. I would like to be able to sort by all machines, and certain time periods.
Eventually I would like to be able to graph based on, waste per machine, or total waste of all machines.
Any help would be greatly appreciated. I am just getting used to Pivot Tables.
Bookmarks