cellclick

Events

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">The component will appear here</div>

JavaScript

function setReport() {
  pivot.setReport({
    "dataSource": {
      "filename": "https://cdn.flexmonster.com/data/data.csv"
    },
    "slice": {
      "rows": [{
          "uniqueName": "Country"
        },
        {
          "uniqueName": "Category"
        },
        {
          "uniqueName": "[Measures]"
        }
      ],
      "columns": [{
        "uniqueName": "Color"
      }],
      "measures": [{
          "uniqueName": "Price",
          "aggregation": "sum",
          "format": "currency"
        },
        {
          "uniqueName": "Discount",
          "aggregation": "average"
        }
      ]
    },
    "tableSizes": {
      "columns": [{
          "idx": 1,
          "width": 0
        },
        {
          "idx": 4,
          "width": 0
        },
        {
          "idx": 5,
          "width": 0
        }
      ]
    }
  });
}

function update() {
flexmonster.on('reportcomplete', function() {
  flexmonster.off('reportcomplete');
  setReport();
});
  pivot.updateData({
    type: 'csv',
    filename: 'https://cdn.flexmonster.com/data/data.csv'
  });
}

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      filename: "https://cdn.flexmonster.com/data/data.csv"
    },
    slice: {
      rows: [{
          uniqueName: "Country"
        },
        {
          uniqueName: "Category"
        },
        {
          uniqueName: "[Measures]"
        }
      ],
      columns: [{
        uniqueName: "Color"
      }],
      measures: [{
          uniqueName: "Price",
          aggregation: "sum",
          format: "currency"
        },
        {
          uniqueName: "Discount",
          aggregation: "average"
        }
      ]
    }
  }
});

flexmonster.on('cellclick', function(cell) {
  alert(
    "Click on cell - row: " +
    cell.rowIndex + ", column: " +
    cell.columnIndex +
    ", label: " +
    cell.label);
});

/*...