Now that we have Pivot Table, Within the Pivot Table you just added, click ‘More Tables…’. Click OK in the pop-up window. we want to allow you to add the rest of the workbook tables’ fields to the Pivot Table. This will make it possible for you to drill up and down within all the related data in the workbook. We can use the Quick Explore Click cell B4, which shows the Sum of TotalProductCost for 2008/Q3. A magnifying glass symbol will appear, click it, then select ‘Products’ and feature to explore different cuts ‘Drill To Product’ in the Explore view. and views of your data in a click, and discover new insights hidden in your data. In a click, conduct a cross-tab analysis of large datasets and get a view of what your data can show you. In this case, we want to see what products make up total product costs within Q3 of 2008. You can see that Bikes make up all of the costs from Q3 for 2008. Quick Explore can also be used with PivotCharts, whether they are linked to Pivot Tables or independent. Financial statements, like this Open Statement 2012-11.xlsm and the “P&L Statement” worksheet. one here, are often the most Click on the INQUIRE tab on the top and then click ‘Workbook Analysis’. mission critical spreadsheets in a company but are also sometimes exposed to potential unwanted errors when employees have access to them. With Spreadsheet Inquire, take control, help mitigate risk, and improve compliance by diagnosing your mission critical workbooks for errors, inconsistencies, hidden information, and other important aspects.
Now that we have Pivot Table, we want to allow you to add the rest of the workbook tables’ fields to the Pivot Table. This will make it possible for you to drill up and down within all the related data in the workbook. Within the Pivot Table you just added, click ‘More Tables…’. Click OK in the pop-up window. We can use the Quick Explore feature to explore different cuts and views of your data in a click, and discover new insights hidden in your data. In a click, conduct a cross-tab analysis of large datasets and get a view of what your data can show you. In this case, we want to see what products make up total product costs within Q3 of 2008. Click cell B4, which shows the Sum of TotalProductCost for 2008/Q3. A magnifying glass symbol will appear, click it, then select ‘Products’ and ‘Drill To Product’ in the Explore view. You can see that Bikes make up all of the costs from Q3 for 2008. Quick Explore can also be used with PivotCharts, whether they are linked to Pivot Tables or independent. Financial statements, like this one here, are often the most mission critical spreadsheets in a company but are also sometimes exposed to potential unwanted errors when employees have access to them. With Spreadsheet Inquire, take control, help mitigate risk, and improve compliance by diagnosing your mission critical workbooks for errors, inconsistencies, hidden information, and other important aspects. Open Statement 2012-11.xlsm and the “P&L Statement” worksheet. Click on the INQUIRE tab on the top and then click ‘Workbook Analysis’.