Highlight a certain measure on the grid
Customizing the grid
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
CSS
@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);
#fm-pivot-view .fm-grid-view div.fm-cell[measure="Price"] {
background-color: #80CBC4 !important;
}
#fm-pivot-view .fm-grid-view div.fm-cell[measure="Quantity"] {
background-color: #FFCC80 !important;
}
#fm-pivot-view .fm-grid-view div.fm-cell[measure="Discount"] {
background-color: #81D4FA !important;
}
JavaScript
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
customizeCell: customizeCellFunction,
report: {
"dataSource": {
"filename": "data/data.csv"
},
"slice": {
"rows": [{
"uniqueName": "Country"
}, {
"uniqueName": "Business Type"
}, {
"uniqueName": "Category"
}, {
"uniqueName": "[Measures]"
}],
"columns": [{
"uniqueName": "Color"
}],
"measures": [{
"uniqueName": "Price"
}, {
"uniqueName": "Quantity"
}, {
"uniqueName": "Discount"
}]
}
}
});
function customizeCellFunction(cell, data) {
if (data.measure) {
cell.attr.measure = data.measure.name;
}
}