Docs - filteropen
by Sohan Soni
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
<script src="https://s3.amazonaws.com/flexmonster/2.3/flexmonster.js"></script>
<div id="pivotContainer">The component will appear here</div>
JavaScript
var pivot = $("#pivotContainer").flexmonster({
componentFolder: "https://s3.amazonaws.com/flexmonster/2.3/",
toolbar: true,
beforetoolbarcreated: customizeToolbar,
report:
{
dataSource: {
data: [
{
"BOOK": "01AA",
"CPTY": "SCLM",
"MKT": "FX",
"COMP": "USD",
"DMO": "2017-06-01",
"TT2ICODE": 22,
"QTY": 0,
"VALUE": -1750,
"DELTA": 0,
"DEAL_TYPE": "SHAPE",
"BOOKGROUP": "ALL",
"ZACTIVE": 4,
"ROWID": 97,
"ZREFRESH": 4058576
}, {
"BOOK": "01AA",
"CPTY": "SCLM",
"MKT": "FX",
"COMP": "USD",
"DMO": "2017-11-01",
"TT2ICODE": 1,
"QTY": 0,
"VALUE": -126125,
"DELTA": 0,
"DEAL_TYPE": "PHYSICAL",
"BOOKGROUP": "ALL",
"ZACTIVE": 102,
"ROWID": 98,
"ZREFRESH": 4058577
}, {
"BOOK": "01AA",
"CPTY": "SCLM",
"MKT": "NYMEX",
"COMP": "ALP7",
"DMO": "2017-11-01",
"TT2ICODE": 24,
"QTY": -275,
"VALUE": -550,
"DELTA": -275,
"DEAL_TYPE": "INDEX PHYSICAL",
"BOOKGROUP": "ALL",
"ZACTIVE": 150,
"ROWID": 99,
"ZREFRESH": 4058578
}, {
"BOOK": "01AA",
"CPTY": "SCLM",
"MKT": "NYMEX",
"COMP": "HOUR",
"DMO": "2017-06-01",
"TT2ICODE": 24,
"QTY": -876,
"VALUE": -876,
"DELTA": -876,
"DEAL_TYPE": "INDEX PHYSICAL",
"BOOKGROUP": "ALL",
"ZACTIVE": 6,
"ROWID": 100,
"ZREFRESH": 4058579
}, {
"BOOK": "1111",
"CPTY": "01GAS-CP1",
"MKT": "22",
"COMP": "22",
"DMO": "2017-04-01",
"TT2ICODE": 22,
"QTY": 31680,
"VALUE": 243880,
"DELTA": 31680,
"DEAL_TYPE": "SHAPE",
"BOOKGROUP": "ALL",
"ZACTIVE": 320,
"ROWID": 101,
"ZREFRESH": 4066399
}, {
"BOOK": "1111",
"CPTY": "01GAS-CP1",
"MKT": "ALN5",
"COMP": "PL",
"DMO": "2017-04-01",
"TT2ICODE": 1,
"QTY": 145440,
"VALUE": 145440,
"DELTA": 145440,
"DEAL_TYPE": "PHYSICAL",
"BOOKGROUP": "ALL",
"ZACTIVE": 100,
"ROWID": 102,
...