I have a pivot table for customer orders that shows the qty ordered of an item broken down by Category of an item the customer and the date. I would like to be able to show updates of what items on orders have been picked in shipping on this report. I am not sure how to do this in the pivot table. Below would be an example of the pivot table data pivot table layout. I would like to change color of cell for Category1/Item1/Customer4/8-Jan to indicate when "ScheduledQty" is any value other than zero. Is this even possible in a pivot table? Thanks for any help.
OrdNum Item Category Qty ShipDate ScheduledQty
4 Item1 Category1 1 8-Jan 1
2 Item1 Category1 3 13-Jan 0
5 Item1 Category1 6 7-Jan 0
2 Item2 Category1 5 13-Jan 0
2 Item3 Category2 3 13-Jan 0
4 Item4 Category2 1 8-Jan 0
Row Labels 7-Jan 8-Jan 9-Jan 13-Jan
Category1
Item1
Customer4 1
Customer2 3
Customer5 6
Item2
Customer2 5
Category2
Item3
Customer2 3
Item4
Customer4 1
OrdNum Item Category Qty ShipDate ScheduledQty
4 Item1 Category1 1 8-Jan 1
2 Item1 Category1 3 13-Jan 0
5 Item1 Category1 6 7-Jan 0
2 Item2 Category1 5 13-Jan 0
2 Item3 Category2 3 13-Jan 0
4 Item4 Category2 1 8-Jan 0
Row Labels 7-Jan 8-Jan 9-Jan 13-Jan
Category1
Item1
Customer4 1
Customer2 3
Customer5 6
Item2
Customer2 5
Category2
Item3
Customer2 3
Item4
Customer4 1