In the Excel PivotTable Options dialog box, there are lots of settings that you can turn on or off. Most of the settings work the way you’d expect, but the “Show the Values Row” option might not seem to do anything. You turn it on and off, and nothing changes. Here’s an explanation of how, and when, the “Show the Values Row” pivot table option works, and you can see the steps in the video below.
Year: 2019
Allow or Block Pivot Table Features
After you set up an Excel pivot table, use macros to allow or block pivot table features and commands. That should discourage other people from making layout changes, which could affect other parts of your Excel workbook.
Get Pivot Chart Title from a Report Filter Cell
Instead of typing a pivot chart title, which never changes, use this method to create a dynamic heading. See how to create a formula on a worksheet, then link to that cell, to create a pivot chart title from a report filter cell.
Continue reading “Get Pivot Chart Title from a Report Filter Cell”
Count Missing Pivot Table Data as Zero
Pivot tables are great at summarizing data, but sometimes your data has gaps, and the pivot tables can’t report on numbers that don’t exist. In today’s example, we have health and safety data for the first quarter. Two departments did not have data for that period, and are not listed in the data, but we’d like the report to show zero incidents. Keep reading, to see how to count missing pivot table data as zero.