| Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows? |
| Written by Vidas Matelis |
| Tuesday, 05 January 2010 23:23 |
|
Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows? A: Select PowerPivot, then from the ribon choose menu item "Design" and then click on "Grand Totals". You will have 4 options:
|
Author articles
- DAX cheat sheet
- Slicer impact on PowerPivot query performance
- Changing how PowerPivot handles DAX errors
- Q: How can I see what internal commands PowerPivot executes in its engine?
- PowerShell Script - Calculate how much space each table uses in the PowerPivot workbook
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
