 
|
To focus on specific data in a pivot table, you can use report filters or field filters. However, using those filters affects the pivot table subtotals and grand totals. Only the amounts for the filtered data are included in the results. Collapse or Expand the Fields Another option for hiding the [...] Happy New Year! I hope you had a safe and happy New Year's Eve celebration, and are off to a good start in 2012. Things got a bit rowdy at the Contextures office party, and I found these guys passed out on the floor, the next morning. Change All Pivot Table Filters Despite the [...] If you have similar data on two or more worksheets, you might want to combine that data in a pivot table, to show the summarized results. Unfortunately, the pivot table from data on multiple sheets can be a disappointment. Create a Pivot Table with Programming A couple of years ago, Excel MVP, Kirill Lapin [...] Welcome back! The Contextures Blog was out of commission for a couple of weeks, and it's nice to be up and running again. A few of the shingles blew off during the reconstruction, so if you notice anything missing or broken, please let me know! Focus on Data with Report Filter Fields Now that [...] This week, I was updating the GetPivotData Function page on my website, and remembered how hard it was to turn off that feature, in Excel 2003 and earlier. We won't even talk about the really olden days (Excel 2000), when you had to type those tricky GetPivotData formulas yourself! Automatic FormulasIf you try to [...] Usually, it's easy to sort an Excel pivot table – just click the drop down arrow, and select one of the sort options.
Every now and then, the pivot table doesn't sort the way that you'd expect. In this example, there are sales representative names in column A, and they have been sorted [...] If your Excel data is in monthly columns, like the worksheet shown below, you'll have trouble setting up a flexible pivot table. Instead of multiple columns with sales amounts, rearrange your data into a single column of amounts. Adjacent columns will show the product name and month. Rearrange the Data With a [...] Last week, Chandoo interviewed me for his Online Excel VBA School, and we talked about using VBA with Excel Pivot Tables. If you drop a field into the Values area, and that field contains blank cells or text, it's added as "Count of", instead of "Sum of".
With a macro, [...] With the pivot table Show Details feature in Excel, a new sheet is inserted when you double-click on the value cell in a pivot table. It's a great feature for drilling into the details, but you can end up with lots of extra sheets in your workbook. Usually, you don't want to save the [...] Recently, we saw how you can use Excel Slicers, to filter fields in one or more pivot tables. In the comments of that article, James asked how to keep those Slicers from overlapping the pivot tables. Does anyone know how to stop slicers moving around when you make selections. This happens if the slicers [...] |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
