JavaScript
flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", {
licenseKey: "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I",
configuratorActive: false,
showHeaders:false,
data: getData(),
formats: [
{name: "currency", decimalPlaces: 2, currencySymbol: "$",
currencySymbolAlign: "right"}
],
rows: [{ uniqueName: "Color" }],
columns: [
{ uniqueName: "[Measures]" }
],
measures: [
{ uniqueName: "Price", aggregation: "sum", format: "currency", active: true},
{ uniqueName: "Quantity", aggregation: "sum", active: true}
],
jsPivotUpdateHandler: onUpdate
}, true);
function onUpdate() {
var gridRowCount = flexmonster.gridRowCount();
console.log(">>>",gridRowCount);
}
function getData() {
return [{
"Color": "green",
"M": "September",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 174,
"Quantity": 22
}, {
"Color": "red",
"M": "March",
"W": "Mon",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": 1664,
"Quantity": 19
}, {
"Color": "red",
"M": "January",
"W": "Mon",
"country": "Canada",
"state": "Quebec",
"city": "Montreal",
"Price": 1190,
"Quantity": 292
}, {
"Color": "green",
"D": "04/08/2014",
"M": "August",
"W": "Fri",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": 1222,
"Quantity": 730
}, {
"Color": "white",
"M": "March",
"W": "Wed",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": 7941,
"Quantity": 73
}, {
"Color": "red",
"M": "August",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 6829,
"Quantity": 19
}, {
"Color": "green",
"M": "January",
"W": "Wed",
...