Flexmonster - Filtering
HTML
<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>
JavaScript
var jsondata = [{
"Color": "green",
"M": "September",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 174,
"Quantity": 22
}, {
"Color": "red",
"M": "September",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 174,
"Quantity": 22
}];
var report = {
configuratorActive: false,
data: jsondata,
pages: [{
uniqueName: "Color",
filter: {
members: ["Color.[green]"]
}
}],
rows: [{
uniqueName: "city",
filter: {
members: ["city.[Toronto]"]
}
}, ],
columns: [{
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price"
}, {
uniqueName: "Quantity"
}],
formats: [{
name: "",
nullValue: "blank"
}]
};
report.licenseKey = "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I";
flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", report, true);
console.log(flexmonster.getColumns))