HighLight the Grand Total row
Flexmonster example to highlight grand total row in the FLAT layout Grit
by Sundarapandiyan_pa
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container">The component will appear here</div>
CSS
.fm-cell.fm-grand-total {
background-color: rgba(128, 194, 242, 0.5) !important;
}
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
height: 500,
report: {
"slice": {
"rows": [
{
"uniqueName": "City"
}
],
"columns": [
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "Net_Sales"
},
{
"uniqueName": "Avg_Check"
},
{
"uniqueName": "Check_Count",
"active": true
},
]
},
"options": {
"grid": {
"type": "classic",
"showTotals": "off",
"showHeaders": false,
"showGrandTotals": "on"
}
},
"dataSource": {
"data": [
{
"City": {
"type": "string"
},
"Net_Sales": {
"type": "number"
},
"Avg_Check": {
"type": "number"
},
"Check_Count": {
"type": "number"
}
},
{
"City": "Delhi",
"Net_Sales": 509.60000038147,
"Avg_Check": 138.10000038147,
"Check_Count": 54
},
{
"City": "Mumbai",
"Net_Sales": 789.60000038147,
"Avg_Check": 254.10000038147,
"Check_Count": 29
},
{
"City": "Chennai",
"Net_Sales": 4154.60000038147,
"Avg_Check": 365.10000038147,
"Check_Count": 35
},
{
"City": "Bangalore",
"Net_Sales": 741.60000038147,
"Avg_Check": 745.10000038147,
"Check_Count": 40
...