Number format in JSP PivotGrid

21 Jun 20229 minutes to read

Allows you to specify the required number format that pivot grid should use in its values by setting the format option. Following are the number formats that are supported:

  • number
  • decimal
  • currency
  • percentage
  • date
  • time
  • scientific
  • accounting
  • fraction
  • string

Relational

  • HTML
  • <div class="cols-sample-area">
    <ej:pivotGrid id="PivotGrid1" load="onLoad">
    <ej:pivotGrid-dataSource>
    <ej:pivotGrid-dataSource-rows>
    <ej:pivotGrid-dataSource-row fieldName="Country" fieldCaption="Country"></ej:pivotGrid-dataSource-row>
    <ej:pivotGrid-dataSource-row fieldName="Product" fieldCaption="Product"></ej:pivotGrid-dataSource-row>
    </ej:pivotGrid-dataSource-rows>
    <ej:pivotGrid-dataSource-columns>
    <ej:pivotGrid-dataSource-column fieldName="Product" fieldCaption="Product"></ej:pivotGrid-dataSource-column>
    </ej:pivotGrid-dataSource-columns>
    <ej:pivotGrid-dataSource-values>
    <ej:pivotGrid-dataSource-value fieldName="Amount" fieldCaption="Amount" format="currency"></ej:pivotGrid-dataSource-value>
    <ej:pivotGrid-dataSource-value fieldName="Quantity" fieldCaption="Quantity" format="decimal"></ej:pivotGrid-dataSource-value>
    </ej:pivotGrid-dataSource-values>
    </ej:pivotGrid-dataSource>
    </ej:pivotGrid>
    </div>
    <script type="text/javascript">
    
        function onLoad(args) {
            args.model.dataSource.data = [
    	                       { Amount: 100, Country: "Canada", Date: "FY 2005", Product: "Bike", Quantity: 2, State: "Alberta" },
    	                       { Amount: 200, Country: "Canada", Date: "FY 2006", Product: "Van", Quantity: 3, State: "British Columbia" },
    	                       { Amount: 300, Country: "Canada", Date: "FY 2007", Product: "Car", Quantity: 4, State: "Brunswick" },
    	                       { Amount: 150, Country: "Canada", Date: "FY 2008", Product: "Bike", Quantity: 3, State: "Manitoba" },
    	                       { Amount: 200, Country: "Canada", Date: "FY 2006", Product: "Car", Quantity: 4, State: "Ontario" },
    	                       { Amount: 100, Country: "Canada", Date: "FY 2007", Product: "Van", Quantity: 1, State: "Quebec" },
    	                       { Amount: 200, Country: "France", Date: "FY 2005", Product: "Bike", Quantity: 2, State: "Charente-Maritime" },
    	                       { Amount: 250, Country: "France", Date: "FY 2006", Product: "Van", Quantity: 4, State: "Essonne" },
    	                       { Amount: 300, Country: "France", Date: "FY 2007", Product: "Car", Quantity: 3, State: "Garonne (Haute)" },
    	                       { Amount: 150, Country: "France", Date: "FY 2008", Product: "Van", Quantity: 2, State: "Gers" },
    	                       { Amount: 200, Country: "Germany", Date: "FY 2006", Product: "Van", Quantity: 3, State: "Bayern" },
    	                       { Amount: 250, Country: "Germany", Date: "FY 2007", Product: "Car", Quantity: 3, State: "Brandenburg" },
    	                       { Amount: 150, Country: "Germany", Date: "FY 2008", Product: "Car", Quantity: 4, State: "Hamburg" },
    	                       { Amount: 200, Country: "Germany", Date: "FY 2008", Product: "Bike", Quantity: 4, State: "Hessen" },
    	                       { Amount: 150, Country: "Germany", Date: "FY 2007", Product: "Van", Quantity: 3, State: "Nordrhein-Westfalen" },
    	                       { Amount: 100, Country: "Germany", Date: "FY 2005", Product: "Bike", Quantity: 2, State: "Saarland" },
    	                       { Amount: 150, Country: "United Kingdom", Date: "FY 2008", Product: "Bike", Quantity: 5, State: "England" },
    	                       { Amount: 250, Country: "United States", Date: "FY 2007", Product: "Car", Quantity: 4, State: "Alabama" },
    	                       { Amount: 200, Country: "United States", Date: "FY 2005", Product: "Van", Quantity: 4, State: "California" },
    	                       { Amount: 100, Country: "United States", Date: "FY 2006", Product: "Bike", Quantity: 2, State: "Colorado" },
    	                       { Amount: 150, Country: "United States", Date: "FY 2008", Product: "Car", Quantity: 3, State: "New Mexico" },
    	                       { Amount: 200, Country: "United States", Date: "FY 2005", Product: "Bike", Quantity: 4, State: "New York" },
    	                       { Amount: 250, Country: "United States", Date: "FY 2008", Product: "Car", Quantity: 3, State: "North Carolina" },
    	                       { Amount: 300, Country: "United States", Date: "FY 2007", Product: "Van", Quantity: 4, State: "South Carolina" }
    	       ];
        }
    
    </script>

    JSP PivotGrid Number Format

    OLAP

  • HTML
  • <ej:pivotGrid id="PivotGrid1">
    <ej:pivotGrid-dataSource catalog="Adventure Works DW 2008 SE" cube="Adventure Works" data="//bi.syncfusion.com/olap/msmdpump.dll">
    <ej:pivotGrid-dataSource-rows>
    <ej:pivotGrid-dataSource-row fieldName="[Date].[Fiscal]"></ej:pivotGrid-dataSource-row>
    </ej:pivotGrid-dataSource-rows>
    <ej:pivotGrid-dataSource-columns>
    <ej:pivotGrid-dataSource-column fieldName="[Customer].[Customer Geography]"></ej:pivotGrid-dataSource-column>
    </ej:pivotGrid-dataSource-columns>
    <ej:pivotGrid-dataSource-values>
    <ej:pivotGrid-dataSource-value axis="columns">
    <ej:pivotGrid-dataSource-value-measures>
    <ej:pivotGrid-dataSource-value-measure fieldName="[Measures].[Internet Sales Amount]" format = "percent"></ej:pivotGrid-dataSource-value-measure>
    </ej:pivotGrid-dataSource-value-measures>
    </ej:pivotGrid-dataSource-value></ej:pivotGrid-dataSource-values>
    </ej:pivotGrid-dataSource>
    </ej:pivotGrid>

    Number-Format OLAP Client