Excel Pivot Table

A pivot table is a table format that can dynamically arrange data and do category summarize strongly. It is commonly used in our daily life for creating summary report. It provides various combinations for row/column/values. Normally we can get the proper table format as we expect after setting group for these fields. As date or… read more »

In daily work, we often need to count the total number for something in different groups, for example count products sales in different seasons. When these products are saved in different groups, do we have a convenient way to do statistic? This article will show you a simple and intuitive way to count data in… read more »

This post will guide you how to repeat row labels in same row in your Pivot table in Excel. How do I repeat all row labels in your pivot table in Excel 2013/2016. How to repeat item labels in a PivotTable. Repeat Item Labels in Pivot Table Repeat Row labels in Pivot Table Repeat Item… read more »

This post will guide you how to hide zero values in a pivot table in Excel. How do I remove rows with zero values in your pivot table. How to hide rows with zero values in pivot table in Excel 2013/2016. Hide Zero Values Video: Hide Zero values Hide Zero Values If you have created… read more »

This post will guide you how to remove grand total from pivot table in excel 2013/2016. How do I remove column grand totals and row grand total in a pivot table in excel. How to hide grand total in an excel pivot table. Remove Grand Total When you created an excel Pivot Table, the grand… read more »