When you are using a Pivot Table in Excel and want to know what data makes up a certain value, all you have to do is double click on that cell.

This will open up a brand new Sheet with all the rows of data that make up that value.

NB. This is an extraction of your data source, so if you edit the information and Refresh your Pivot Table then nothing will happen.  Any changes need to be made in your main data source.

If you want to get rid of this sample data, all you have to do is press CTRL+Z and press DELETE in the pop up pox.

So go ahead and double click on any values (including SubTotals and GrandTotals) within your Pivot Table to view the data that makes up your selected value.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Double click on any value cell within the Pivot Table

This opens up a new sheet with the data that makes up the selected cell.

 

Drill Down to Audit

HELPFUL RESOURCE:

728x90

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis.DOWNLOAD WORKBOOK...
Pivot Table Calculated Item Pivot Table Calculated Items allow you to do mathematical calculations with your Item List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Items can be used to calculate chan...
Show The Percent of Grand Total With Excel Pivot T...  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer.These Slicer Styles add color to your Excel workbook to gives it some much needed life!You can also add columns to a Slicer and you can also find more Slicer options by Right...