Slice defined with rows, columns and measures
Slice configuration
by Viacheslav Mukha
January 04, 2023
HTML
<link rel="stylesheet" href="https://cdn.flexmonster.com/2.3/demo.css">
<!-- Problems observed with version 2.9.40 -->
<script src="https://cdn.flexmonster.com/2.9.40/flexmonster.js"></script>
<!-- Used to work good for version 2.7.23 -->
<!-- <script src="https://cdn.flexmonster.com/2.7.23/flexmonster.js"></script> -->
<!-- <link href="https://cdn.flexmonster.com/2.7.23/flexmonster.min.css" rel="stylesheet"> -->
<div id="pivot-container"></div>
JavaScript
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
"options": {
"configuratorButton": false,
"drillThrough": false,
"showAggregationLabels": false,
"grid": {
"showFilter": true,
"fitGridlines": false,
"showHeaders": false,
"showGrandTotals": "columns"
}
},
"dataSource": {
"dataSourceType": "json",
"data": [
{
"Month": "January",
"Day": "Sunday",
"Segment": "Projected",
"Macro": "BAR",
"Revenue": "16",
"Room Nights": 2,
"Total Occupancy": 1275,
"Occupancy": "0.023",
"Average Daily Rate": "8.0",
"RevPAR": "0.184"
},
{
"Month": "January",
"Day": "Sunday",
"Segment": "Projected",
"Macro": "Comp/House",
"Revenue": "10",
"Room Nights": 2,
"Total Occupancy": 1275,
"Occupancy": "0.001",
"Average Daily Rate": "5.00",
"RevPAR": "0.005"
},
{
"Month": "January",
"Day": "Sunday",
"Segment": "Projected",
"Macro": "Comp/House",
"Revenue": "0",
"Room Nights": 0,
"Total Occupancy": 1275,
"Occupancy": "0.001",
"Average Daily Rate": "0.00",
"RevPAR": "0.00"
},
{
"Month": "January",
"Day": "Monday",
"Segment": "Projected",
"Macro": "BAR",
"Revenue": "20",
"Room Nights": 5,
"Total Occupancy": 1275,
"Occupancy": "0.023",
"Average Daily Rate": "4.0",
"RevPAR": "0.092"
},
{
"Month": "January",
"Day": "Monday",
"Segment": "Projected",
"Macro": "Comp/House",
"Revenue": "22",
"Room...