Ever need to drill down into your Pivot Table to look at the details behind your summary calculations? Simple stuff with the double click of a mouse and Excel will display all of the details behind the summary on a brand new worksheet.
Let’s look at an example.
The Sales of Widget_A have outsold Year to date in 2013 than any other type of Widget. Let’s take a closer look at those sales. We can can double click on cell B4 and drill down to get those details. Easy as that!
That’s it. You can easily see the data behind the sales of Widget_A