In this case, I'll name the sheet "Sales by Product" First, give the worksheet that holds your first pivot table a meaningful name. That might sound like a lot of work, but let me show you an easy way to do it. The simplest approach is to create additional pivot tables, where each pivot table shows a different view of the same data. You're not going to want to make all these changes manually each time. Well, the obvious solution is to rearrange the pivot table to show sales by Customer, instead of sales by Product, and I can easily do this.īut what if this is a sales report that you update weekly or monthly, and you want to always see sales by Product, sales by Customer, and sales by other categories, too? And what if some pivot tables are complicated, and you don't want to monkey with these once they're working well? 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 I have a set of 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. |