Combining styles from different conditional formatting rules

Conditional formatting

by Flexmonster Pivot Table

HTML

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

<button onclick="applyCondition1()">Apply condition 1</button>
<button onclick="applyCondition2()">Apply condition 2</button>
<button onclick="removeAll()">Remove all conditions</button>

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

CSS

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

JavaScript

const pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      filename: "data/sales.csv",
    },
    slice: {
      rows: [
        {
          uniqueName: "Month",
          filter: {
          	exclude: ["January", "February", "December"]
          }
        },
      ],
      columns: [
        {
          uniqueName: "Salesperson",
          filter: {
          	members: ["Andrew Spacey", "Marcus Kowalski", "Michael Fisher", "Robert Cole"]
          }
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Revenue",
          aggregation: "sum",
        },
      ],
    },
    options: {
    	grid: {
      	showGrandTotals: false
      }
    }
  },
});


function applyCondition1() {
  let condition = {
    id: "1",
    formula: "8000 < #value",
    format: {
      backgroundColor: "#FFB74D", // Orange
    },
  };
  pivot.addCondition(condition);
  pivot.refresh();
}

function applyCondition2() {
  let condition = {
    id: "2",
    formula: "#value < 15000",
    format: {
      color: "#8E24AA", // Violet
      fontWeight: "bold"
    },
  };
  pivot.addCondition(condition);
  pivot.refresh();
}

function removeAll() {
  pivot.removeAllConditions();
  pivot.refresh();
}