Tag: report layout

Pivot Table Not Showing All Data Problem-Layout Fix

Pivot tables are great for summarizing data, but do you ever notice that there are missing items in a pivot table?

For example, you know there are product records in the source data table, but one product isn’t showing up in the pivot table. How can you troubleshoot and fix the problem to show all data?

Pivot Table Not Showing All Data
Pivot Table Not Showing All Data

Continue reading “Pivot Table Not Showing All Data Problem-Layout Fix”

Excel Pivot Table Custom Subtotal Limitations

In an Excel pivot table, subtotals are automatically added to the outer fields, when you add more fields below them. You can also add extra subtotals, if needed, by creating custom subtotals for a pivot field. There are some limitations though, which you can see in the video and notes below. Continue reading “Excel Pivot Table Custom Subtotal Limitations”