I think pivot tables are one of the best ways to display data but get the least amount of attention. I say this because I both make and see them everywhere yet had no idea what they were actually called.
The table above is offering an example on food versus how much of one product was sold. This is an especially helpful layout when considering when to add or remove certain products from an itinerary. Being able to see by order or day what products are or aren’t selling is a great way to negate some costs.
Personally, I’m not in the business of needed to see what sells over what as I don’t own a restaurant or store of any kind but I imagine that this could be helpful even in situations that aren’t monetary. I have a large collection of makeup and I think this would be a great way to organize my collection to make sure I get use out of all products.