JSFiddle - React, Tailwind, and code Playground

by Flexmonster Pivot Table

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>

JavaScript

const pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: getData()
    },
    slice: {
      "rows": [{
        "uniqueName": "Referral Marketer"
      }],
      "columns": [
        {
          "uniqueName": "[Measures]"
        }
      ],
      "measures": [{
          "uniqueName": "Formula #1",
          "formula": "if(sum(\"Referral Patient Status Id\") = 1 , count(\"ReferralId\") , 0)",
          "individual": true,
          "caption": "Active"
        },
        {
          "uniqueName": "Lost",
          "formula": "if(sum(\"Referral Patient Status Id\") = 2 , count(\"ReferralId\") , 0)",
          "individual": true,
          "caption": "Lost"
        },
        {
          "uniqueName": "Pending",
          "formula": "if(sum(\"Referral Patient Status Id\") = 3 , count(\"ReferralId\") , 0)",
          "individual": true,
          "caption": "Pending"
        },
        {
          "uniqueName": "Total",
          "formula": "count(\"ReferralId\")",
          "caption": "Total"
        },
        {
          "uniqueName": "Conversion Rate",
          "formula": "\"Formula #1\"  / count(\"ReferralId\")",
          "caption": "Conversion Rate"
        }
      ]
    }
  }
});


function getData() {
  return [{
      "Referral Marketer": "Cameron George",
      "Referral Patient Status": "Admitted",
      "ReferralId": "randomId1",
      "Referral Patient Status Id": 1
    },
    {
      "Referral Marketer": "Cameron George",
      "Referral Patient Status": "Admitted",
      "ReferralId": "randomId2",
      "Referral Patient Status Id": 1
    },
    {
      "Referral Marketer": "Cameron George",
      "Referral Patient Status": "Admitted",
      "ReferralId": "randomId3",
      "Referral Patient Status Id": 1
    },
    {
      "Referral Marketer": "Cameron George",
      "Referral Patient Status": "Lost",
      "ReferralId": "randomId4",
...