Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows?
User Rating: / 1
PoorBest 
Written by PowerPivot-Info.com   
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:

  • Off for Rows and Columns
  • On for Rows and Columns
  • On for Rows Only
  • On for Columns Only

id201-grandtotal1

 

  Tags: excel, format, faq
 

Pyramid+PowerPivot