Sub Total Hiding

22 May 20171 minute to read

NOTE

This feature is applicable only for Relational data source.

You can hide the Sub Total for respective fields in rows and columns by setting the property showSubTotal to false

HTML

<script type="text/babel">
        //..         
        var  pivotdataSource = {
            data: pivot_dataset,
            rows: [{ fieldName: "Country", fieldCaption: "Country", showSubTotal: false },{ fieldName: "State", fieldCaption: "State" }],
            columns: [{ fieldName: "Product", fieldCaption: "Product" }],
            values: [{ fieldName: "Amount", fieldCaption: "Amount" },{ fieldName: "Quantity", fieldCaption: "Quantity" }],
            filters: []
        };
        //..
    </script>