As a seasoned Excel user, you are no doubt familiar with Pivot Tables and how they work. (If not, here's a great place to get started on them:. Perhaps you've wanted to see your pivot table data differently. We know how to pivot the tables to display our data as needed, but what if we need to see all of the data for a field in a single flat format? How can we do this? Consider the following sample pivot table: In order to show the data in flat file format, we need to be showing Grand Totals as we are with this table.
![View View](/uploads/1/2/5/6/125632902/541876296.jpg)
If you aren't seeing grand totals, right click in your pivot table, left click PivotTable options. Click the 'Totals & Filters' tab and make sure both 'Show grand totals for rows' and 'Show grand totals for columns' are checked. To display the data in a flat format, just double click the Grand total. What you get is the flat data (like the sample below) on a new tab added to your workbook.
As well as the built-in AutoFormat, Pivot Table AutoFormat XL is designed for formatting your pivot tables. But unlike the built-in AutoFormat, Pivot Table AutoFormat XL: - Creates and applies your own formatting templates. - Doesn't change the layout of your pivot table. Watch video Welcome to Excel 2016 for Mac: Pivot Tables in Depth. In this course, I'll show you how to use Pivot Tables to gain valuable insights from your organization's data. I'll begin by showing you how to create a Pivot Table from data already in your Excel workbooks.