In an Excel pivot table, you might want to hide one or more of the items in a Row field or Column field. To do that, you can click the drop down arrow for the Row or Column Labels, then remove the check mark for items you want to remove. For example, to hide the [...]

With Excel Pivot Table filters, you can limit the results to a specific part of your data. For example, you can view only the sales from the previous month, or see the products with more than $500 in sales. If you’re interested in analyzing the best or worst results in your data, use the Top [...]

If there’s a date field in your Excel pivot table, you can use it to focus on a specific date, or a selected date range. To filter the dates, you can use the following filter types: Date checkboxes Date range entry Dynamic date range selection Using Date Checkboxes If a date field is in the [...]