Pivot tables have an interesting feature that allows you to do just that.
Let’s take a look.
Here we have a pivot table that contains product sales organized by year and city.
But what if you want to see the data behind that number?
For example, suppose you want to see the data behind the Boston 2012 number of 5,395.
In this case, we have 68 entries for sales in Boston for 2012.
These rows are an exact copy of the rows that appear in the source data.
In this example, a total of almost 1,000 rows of data.
you could change, copy, or move this data as you like without affecting the existing pivot table.
You could also use this extracted data as the source for another pivot table.
When you have no further use of the drill-down data, you are free to delete the worksheets altogether.
