Custom sort order for CSV

Slice configuration

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<div id="pivot-container"></div>


<div><button onclick=call();> Change sort</button></div>

JavaScript

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  toolbar: true,
  report: {
    "dataSource": {
      "filename": "data/data.csv"
    },
   
  }
});


function call(){

var json =  {"slice": {
      "rows": [{
        "uniqueName": "Category",
        "sortOrder": [
          "Bikes",
          "Cars",
          "Clothing",
          "Accessories",
          "Components"
        ]
      }],
      "measures": [{
        "uniqueName": "Color"
      }]
    }
    }
    
flexmonster.runQuery(json);
}