Apply or remove sorting using the sortValues API call

Slice configuration

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<button onclick="sortValues()">Sort Values</button>
<button onclick="removeSorting()">Remove sorting</button>

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

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  report: {
    dataSource: {
      filename: "data/data.csv"
    },
    slice: {
      rows: [{
        uniqueName: "Destination"
      }],
      columns: [{
          uniqueName: "Category",
          filter: {
            exclude: [
              "category.[accessories]"
            ],
          }
        },
        {
          uniqueName: "Color",
          filter: {
            members: [
              "color.[blue]",
              "color.[red]"
            ]
          }
        },
        {
          uniqueName: "[Measures]"
        }
      ],
      measures: [{
        uniqueName: "Price"
      }],
      expands: {
        columns: [{
          tuple: ["category.[bikes]"]
        }]
      }
    }
  }
});

function sortValues() {
  pivot.sortValues(
    "columns",
    "asc",
    ["category.[bikes]", "color.[red]"], 
    {"uniqueName": "Price"}
  );
}

function removeSorting() {
	pivot.sortValues(
  	"columns", 
    "unsorted",
    ["category.[bikes]", "color.[red]"], 
    {"uniqueName": "Price"}
  );
}