Show the number of rows on the flat form

Calculated measures

by yahmed

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,
    report: {
        "dataSource": {
            "dataSourceType": "csv",
            "filename": "data/data.csv"
        },
        "slice": {
            "rows": [
            {
                    "uniqueName": "Category",
                    "sort": "asc"
                },
                {
                    "uniqueName": "Size",
                    "sort": "asc"
                },
            {
                    "uniqueName": "Color",
                    "sort": "asc"
                }
            ],
            "columns": [{
                "uniqueName": "Country",
                "sort": "asc"
            },
                {
                    "uniqueName": "[Measures]"
                }],
            "measures": [{
                    "uniqueName": "Price",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "R. Number",
                    "formula": "average(\"Price\") ",
                    "caption": "Average Price"
                }
            ],
            "flatOrder": [
                "R. Number",
                "Color",
                "Country",
                "Price"
            ]
        },
        "options": {
            "grid": {
                "type": "classic"
            }
        }
    }
});