A Few More PivotTable Improvements in Excel 2010
In today’s post I will be covering a couple of smaller PivotTable features that we incorporated in Excel 2010. Most of these features have been longstanding customer requests or pain points that we felt could be addressed in this release. This includes fixing functionality that worked in versions of Excel previous to Excel 2007 (Filtering on calculated members) as well as making it easier to access features that historically our users have had a hard time finding (Show As calculations).
These features include:
- New additions to “Show As” including adding access to this feature via the right click menu.
- Repeat down labels
- Advanced filtering with calculated members.
- Ability to toggle Visual Totals ON/OFF for PivotTables and sets.