CSV data source

Data source

by Flexmonster Pivot Table

HTML

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

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

JavaScript

var pivot = new Flexmonster({
    container: "pivot-container",
    componentFolder: "https://cdn.flexmonster.com/",
    toolbar: true,
    customizeCell: customizeCellFunction,
    report: {
        "dataSource": {
            "dataSourceType": "csv",
            "filename": "data/data.csv"
        },
        "slice": {
            "rows": [{
                    "uniqueName": "Color",
                    "sort": "asc"
                },
                {
                    "uniqueName": "[Measures]"
                }
            ],
            "columns": [{
                "uniqueName": "Country",
                "sort": "asc"
            }],
            "measures": [{
                    "uniqueName": "Price",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "R. Number",
                    "formula": "count(\"Price\") ",
                    "caption": "R. Number"
                }
            ],
            "flatOrder": [
                "R. Number",
                "Color",
                "Country",
                "Price"
            ]
        },
        "options": {
            "grid": {
                "type": "flat"
            }
        }
    }
});
function customizeCellFunction(cell, data) {
			var viewType = flexmonster.getOptions()["grid"]["type"];
			if (viewType != "flat") return;

			if (data.type == "value" && data.columnIndex == 0 && data.rowIndex > 1) {
				cell.text = data.rowIndex - 1;
			}
		}