Pivot-table - pivot-table.com - Excel Pivot Tables
General Information:
Latest News:
Add All Remaining Fields to Pivot Table 21 Aug 2013 | 09:01 am
After you create a pivot table, you can add or remove fields by using the check boxes in the field list. Text fields are automatically added to the Row Labels area, and numeric fields go into the Valu...
Changing Pivot Chart Affects Excel Pivot Table 14 Aug 2013 | 09:02 am
After you create a pivot table, you can insert a pivot chart, based on that pivot table. However, if you change the layout of the pivot chart, it will also change the pivot table’s layout. For exampl...
Prevent Changes to Pivot Table Setup 7 Aug 2013 | 09:01 am
After you set up a pivot table, you might want to prevent other people from making changes to the way that it is set up. With a bit of programming, you can restrict what happens to a pivot table. Usu...
Show Survey Responses in Pivot Chart 31 Jul 2013 | 09:01 am
I’ve updated one of the pivot chart sample files on my Contextures website. On the main sheet, there are two pivot charts, showing survey responses by department, and by years of service. At the top ...
Scroll Through Report Filter Items 24 Jul 2013 | 09:02 am
In Excel 2010, slicers were added to Excel, and they make it easy to select one or more items in a pivot table’s Report Filter. If you have an older version of Excel, or if you don’t have room for sl...
Running Total Stops at Year End 17 Jul 2013 | 09:01 am
A quick way to show how amounts accumulate over time is to build a pivot table, and show the values as a running total. However, if you group the dates by year and month, the running total stops at t...
Create a Pivot Table in Excel 2013 10 Jul 2013 | 09:02 am
There is a new feature in Excel 2013, that makes it even easier to get started with pivot tables. Just select a cell in your source data table, and on the Ribbon’s Insert tab, click Recommended Pivot...
Show and Hide Pivot Table Details 3 Jul 2013 | 09:01 am
In a pivot table, you can show all the summarized data, or focus on specific details. One way to hide information is with filtering, and that affects the pivot table totals. In the screen shot below,...
Show Percent of Subtotal in Pivot Table 26 Jun 2013 | 09:02 am
A pivot table is a great way to summarize data in Excel, and you can show sums, counts, averages, and other functions. Use Custom Calculations In addition to the different functions, you can apply c...
Group and Ungroup Text Items in Pivot Table 19 Jun 2013 | 09:01 am
The Grouping dialog box isn’t available if you try to group items in a text field. Instead, you can manually group the items. Select the all of the items that you want to group Right-click on one of t...
