Show Grand Totals

Defines whether to display the totals and grand totals for the measures.

In the following example, if ShowGrandTotals is set to false.

<Pivot>
 <PivotName>BooksStoreCharts</PivotName>
 <Rows>
  <FieldName>Title</FieldName>
  <FieldName>Genre</FieldName>
 </Rows>
 <Columns>
  <FieldName>AvailableOnline</FieldName>
  <FieldName>ISBN</FieldName>
 </Columns>
 <Measures>
  <FieldName>Rating</FieldName>
 </Measures>	
 <ShowGrandTotals>false</ShowGrandTotals>		
</Pivot>
   

Following is an example when the ShowGrandTotals is true.

Following is an example when the ShowTotals is false.