In this video, I’ll show you how to base one pivot table on another.
Here I have a set of sales data for chocolate products.
I’ve also got another month’s worth of sales data in this second sheet.
We’ll get to that in a minute.
Now that we have the pivot table set up, we have a nice breakdown of sales by Product.
But suppose you want to look at sales by Customer?
You’re not going to want to make all these changes manually each time.
First, give the worksheet that holds your first pivot table a meaningful name.
Next, adjust the pivot table as needed to show the breakdown you want.
Now I have two pivot tables, both linked to the same data.
This mimics the process of updating a report on an ongoing basis.
Before I refresh the data, notice that the total in each pivot table is about $21,000.
And if I check the second pivot table, we see the same total there too.
