Number format

9 Mar 20189 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>

    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>