GrapeCity.Documents.Excel.IPivotTable.GrandTotalName

GrandTotalName Property

GrandTotalName

Gets or sets the text label displayed in the grand total row heading or grand total column heading of the PivotTable report.

The default label is "Grand Total".

Declaration

string GrandTotalName { get; set; }

Property GrandTotalName As String

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Region", "Sales"},
    {"East", 100},
    {"West", 200},
    {"East", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
string grandTotalName = pivotTable.GrandTotalName;