Styling rows based on the conditional formatting
Customizing the grid
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="update()">update</button>
<div id="pivot-container"></div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 500,
toolbar: true,
report: {
"dataSource": {
"data": getData(),
"mapping": {
"Org_key_name": {
"type": "string"
},
"ScenarioName": {
"type": "string"
},
"Actual": {
"type": "number"
},
"Actual-1": {
"type": "number"
},
"YearSelectionIdd96b09f0-8fbd-d9d7-41b8-ab9133ae44b9": {
"type": "property",
"hierarchy": "Year"
},
"Year": {
"type": "number"
},
"monthSelectionIdd96b09f0-8fbd-d9d7-41b8-ab9133ae44b9": {
"type": "property",
"hierarchy": "month"
},
"month": {
"type": "number"
},
"User": {
"type": "string"
},
"Amount": {
"type": "number"
},
"TimeSelectionIdd96b09f0-8fbd-d9d7-41b8-ab9133ae44b9": {
"type": "property",
"hierarchy": "Time"
},
"Time": {
"type": "time",
"format": "hh:mm:ss TT"
},
"accoPLANNINGId": {
"type": "id"
}
}
},
"options": {
"grid": {
"type": "compact",
"showFilter": false,
"dragging": false,
"showReportFiltersArea": false,
"showTotals": "on",
"showGrandTotals": "off",
"showHeaders": false,
"showHierarchies": true
},
"drillThrough": false,
"configuratorButton": false,
"caseSensitiveMembers": true,
"showEmptyValues": false,
"sorting": "on",
...