![]() But suppose you want to look at sales by customer? ![]() Now that we have the pivot table set up, we have a nice breakdown of sales by product. To start off, I'm going to create a pivot table that shows sales broken down by product, with the top selling products on top. I've also got another month's worth of sales data in this second sheet. Here we have sales data for chocolate products. In this video, I'll show you how to base one pivot table on another. When you have a pivot table set up, you might find that you want another pivot table, to show a different view of the same data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |