﻿ Using Subtotals | SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Formulas / Using Subtotals
In This Topic
Using Subtotals
In This Topic

You can use subtotals in rows.

#### Using Code

This example uses a subtotal formula.

JavaScript
Copy Code
```\$(document).ready(function ()
{
{sheetCount:3});

activeSheet.setColumnCount(2);
activeSheet.options.gridline = {showHorizontalGridline: false};
activeSheet.setText(3, 0, "Sub-Total1");
activeSheet.setText(7, 0, "Sub-Total2");
activeSheet.setText(8, 0, "Aggregate");
activeSheet.getRange(3, -1, 1, -1).backColor("lemonChiffon");
activeSheet.getRange(7, -1, 1, -1).backColor("lemonChiffon");
activeSheet.getRange(8, -1, 1, -1).backColor("lightPink");
activeSheet.setValue(0, 1, 100);
activeSheet.setValue(1, 1, 200);
activeSheet.setValue(2, 1, 300);
activeSheet.setValue(4, 1, 400);
activeSheet.setValue(5, 1, 500);
activeSheet.setValue(6, 1, 600);

// Set the sub-total and the aggregate by using SUBTOTAL function.
activeSheet.setFormula(3, 1, "SUBTOTAL(9,B1:B3)");
activeSheet.setFormula(7, 1, "SUBTOTAL(9,B5:B7)");
activeSheet.setFormula(8, 1, "SUBTOTAL(9,B1:B7)");
});
```