Flexmonster Starter

by Uaman23

HTML

<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>

JavaScript

var p = 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",
  dataSourceType: "json",
    data: getData(),

    //slice with filters, calculated measures, sorting on values
    pages: [{ uniqueName: "Color", filter: { members: ["Color.[blue]"], negation: true } }],
    rows: [{ uniqueName: "M" }],
    columns: [
      { uniqueName: "Geography" },
      { uniqueName: "[Measures]" }
    ],
    measures: [
      { uniqueName: "Price", aggregation: "sum", format: "currency", active: true}, 
      { uniqueName: "Quantity", aggregation: "average", availableAggregations: ["sum", "average"], active: false}, 
      { uniqueName: "Calculated Price per Item", caption: "Calculated Price per Item", calculated: true, formula: "sum('Price') / sum('Quantity')", format: "currency", active: true}
    ],
    rowSorting: {
      measure: "Price",
      tuple: "",
      type: "desc"
    },

    //report options
    configuratorActive: false,
    viewType: "grid"
}, true);

function getData() {
  return [
  {
  "Color":{"type": "string"},
  "M":{"type": "month", "dimensionUniqueName": "Days", "dimensionCaption": "Days", "caption":"Month"},
  "W":{"type": "weekday", "dimensionUniqueName": "Days", "dimensionCaption": "Days", "caption":"Week Day"},
  "country":{"type":"level", "hierarchy": "Geography", "level":"Country"},
  "state":{"type":"level", "hierarchy": "Geography", "level":"State", "parent": "Country"},
  "city":{"type":"level", "hierarchy": "Geography", "parent": "State"},
  "Price":0,
  "Quantity":{"type": "number"}
  },
  {
  "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,
 ...