API call openCalculatedValueEditor

Calculated measures

by Ravi A

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="openCalculatedValueEditor()">Open Calculated Value Editor</button>
<button onclick="openSpecifiedCalculatedValueEditor()">Open Calculated Value Editor For Revenue</button>
<button onclick="openSpecifiedCalculatedValueEditorWithCallback()">Open Calculated Value Editor With Callback</button>
<div id="pivot-container"></div>

JavaScript

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  width: "100%",
  height: 430,
  report: {
    dataSource: {
      type: "json",
      data: []
    },
    slice: {
        rows: [
            {
                uniqueName: "Category"
            }
        ],
        columns: [
            {
                uniqueName: "[Measures]"
            }
        ],
        measures: [
            {
                uniqueName: "Price",
                aggregation: "sum"
            },
            {
                uniqueName: "Revenue",
                formula: "sum(\"Quantity\") * sum(\"Price\")",
                caption: "Revenue"
            }
        ]
    },
  }
});

function openCalculatedValueEditor() {
  flexmonster.openCalculatedValueEditor();
}

function openSpecifiedCalculatedValueEditor() {
  flexmonster.openCalculatedValueEditor("Revenue");
}

function openSpecifiedCalculatedValueEditorWithCallback() {
  flexmonster.openCalculatedValueEditor("Revenue", function(response) {  
  alert("uniqueName: " + response.uniqueName + ", " + "isRemoved: " + response.isRemoved); 
  });
  
  
}