Pinterest Pixel

Drill Down To Audit Using a Pivot Table

When you are using a Pivot Table in Excel and want to know what data makes up... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Drill Down To Audit Using a Pivot Table | MyExcelOnline Drill Down To Audit Using a Pivot Table | MyExcelOnline

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.

Drill Down To Audit Using a Pivot Table | MyExcelOnline

Download excel workbookDrill-Down-to-Audit.xlsx

 

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

See also  Show The Percent of Column Total With Excel Pivot Tables

Drill Down To Audit Using a Pivot Table

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

Drill Down To Audit Using a Pivot Table

 

 

HELPFUL RESOURCE:

728x90

 

 

If you like this Excel tip, please share it
Drill Down To Audit Using a Pivot Table | MyExcelOnline Drill Down To Audit Using a Pivot Table | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...