Globalization and localization in EJ2 TypeScript Pivotview control

25 Jan 202424 minutes to read

Globalization is the combination of Internationalization and localization. You can adapt the component to various languages by parsing and formatting the date or number Internationalization & adding culture specific customization and translation to the text Localization.

Internationalization

Internationalization library provides support for formatting and parsing the number, date, and time by using the official Unicode CLDR JSON data and also provides the loadCldr method to load the culture specific CLDR JSON data.

By default, all the Essential JS 2 component are specific to English culture (‘en-US’). If you want to go with the different culture other than English, follow the below steps.

Install the CLDR-Data package by using the below command (it installs the CLDR JSON data). For more information about CLDR-Data, refer to this link.

npm install cldr-data --save

Once the package installed, you can find the culture specific JSON data under the location /node_modules/cldr-data.

Now import the installed CLDR JSON data into the app.ts file. To import JSON data we need to install the JSON plugin loader. Here we have used the SystemJS JSON plugin loader.

npm install systemjs-plugin-json --save-dev

Once installed, configure the system.config.js configuration settings as like below to map the
systemjs-plugin-json loader.

System.config({
    paths: {
        'syncfusion:': './node_modules/@syncfusion/'
    },
    map: {
        app: 'app',

        //Syncfusion packages mapping
        "@syncfusion/ej2-base": "syncfusion:ej2-base/dist/ej2-base.umd.min.js",
        "@syncfusion/ej2-data": "syncfusion:ej2-data/dist/ej2-data.umd.min.js",
        "@syncfusion/ej2-inputs": "syncfusion:ej2-inputs/dist/ej2-inputs.umd.min.js",
        "@syncfusion/ej2-buttons": "syncfusion:ej2-buttons/dist/ej2-buttons.umd.min.js",
        "@syncfusion/ej2-splitbuttons": "syncfusion:ej2-splitbuttons/dist/ej2-splitbuttons.umd.min.js",
        "@syncfusion/ej2-popups": "syncfusion:ej2-popups/dist/ej2-popups.umd.min.js",
        "@syncfusion/ej2-navigations": "syncfusion:ej2-navigations/dist/ej2-navigations.umd.min.js",
        "@syncfusion/ej2-grids": "syncfusion:ej2-grids/dist/ej2-grids.umd.min.js",
        "@syncfusion/ej2-dropdowns": "syncfusion:ej2-dropdowns/dist/ej2-dropdowns.umd.min.js",
        "@syncfusion/ej2-calendars": "syncfusion:ej2-calendars/dist/ej2-calendars.umd.min.js",
        "@syncfusion/ej2-lists": "syncfusion:ej2-lists/dist/ej2-lists.umd.min.js",
        "@syncfusion/ej2-excel-export": "syncfusion:ej2-excel-export/dist/ej2-excel-export.umd.min.js",
        "@syncfusion/ej2-pdf-export": "syncfusion:ej2-pdf-export/dist/ej2-pdf-export.umd.min.js",
        "@syncfusion/ej2-file-utils": "syncfusion:ej2-file-utils/dist/ej2-file-utils.umd.min.js",
        "@syncfusion/ej2-compression": "syncfusion:ej2-compression/dist/ej2-compression.umd.min.js",
        "@syncfusion/ej2-pivotview": "syncfusion:ej2-pivotview/dist/ej2-pivotview.umd.min.js"
    },
    meta: {
        '*.json': { loader: 'plugin-json' }
    },
    packages: {
        'app': { main: 'app', defaultExtension: 'js' },
        'cldr-data': { main: 'index.js', defaultExtension: 'js' }
    }
});

System.import('app');

Now import the required culture from the installed location to app.ts file, like the below code snippets.

//import the loadCldr from ej2-base
import { loadCldr} from '@syncfusion/ej2-base';

loadCldr(
    require('cldr-data/supplemental/numberingSystems.json'),
    require('cldr-data/main/fr-CH/ca-gregorian.json'),
    require('cldr-data/main/fr-CH/numbers.json'));
    require('cldr-data/main/fr-CH/timeZoneNames.json'));

The Internationalization library is used to globalize number, date, and time values in pivot table component using the dataSourceSettings.formatSettings option.

Set the culture by using the locale property.

index.ts
index.html
import { loadCldr, L10n, setCulture, setCurrencyCode } from '@syncfusion/ej2-base';
import * as currencies from './currencies.json';
import * as cagregorian from './ca-gregorian.json';
import * as numbers from './numbers.json';
import * as timeZoneNames from './timeZoneNames.json';
import * as numberingSystems from './numberingSystems.json';
import { PivotView, IDataSet, FieldList } from '@syncfusion/ej2-pivotview';
import { pivotData } from './datasource.ts';

loadCldr(currencies, cagregorian, numbers, timeZoneNames, numberingSystems);

setCulture('de');
setCurrencyCode('EUR');

L10n.load({
    'de-DE': {
        'pivotview': {
            'grandTotal': 'Gesamtsumme',
            'total': 'Insgesamt',
            'value': 'Wert',
            'noValue': 'Kein Wert',
            'row': 'Zeile',
            'column': 'Spalte',
            'collapse': 'Zusammenbruch',
            'expand': 'Erweitern'
        },
        "pivotfieldlist": {
            'fieldList': 'Feld Liste',
            'dropRowPrompt': 'Drop Reihe hier',
            'dropColPrompt': 'Drop column Hier',
            'dropValPrompt': 'Drop wert hier',
            'dropFilterPrompt': 'Drop Filter Hier',
            'addPrompt': 'Feld hinzufügen',
            'centerHeader': 'Ziehen Sie die Felder zwischen den Bereichen unten:',
            'add': 'Hinzufügen',
            'drag': 'Ziehen',
            'filters': 'Filter',
            'rows': 'Zeilen',
            'columns': 'Spalten',
            'values': 'Werte',
            'error': 'Fehler',
            'dropAction': 'Berechnetes Feld nicht in jeder anderen Region außer Wert Achse sein.',
            'search': 'Suche',
            'close': 'Schließen',
            'cancel': 'Abbrechen',
            'delete': 'Löschen',
            'alert': 'Warnung',
            'warning': 'Warnung',
            'ok': 'OK',
            'allFields': 'Alle Felder',
            'noMatches': 'Keine Treffer'
        }
    }
});

PivotView.Inject(FieldList);
let pivotTableObj: PivotView = new PivotView({
    dataSourceSettings: {
        dataSource: pivotData as IDataSet[],
        expandAll: false,
        enableSorting: true,
        drilledMembers: [{ name: 'Country', items: ['France'] }],
        columns: [{ name: 'Year', caption: 'Production Year' }, { name: 'Quarter' }],
        values: [{ name: 'Sold', caption: 'Units Sold' }, { name: 'Amount', caption: 'Sold Amount' }],
        rows: [{ name: 'Country' }, { name: 'Products' }],
        formatSettings: [{ name: 'Amount', format: 'C2', useGrouping: false,
                minimumSignificantDigits: 1, maximumSignificantDigits: 3, currency: 'EUR' }],
        filters: []
    },
    locale: 'de-DE',
    showFieldList: true,
    height: 350
});
pivotTableObj.appendTo('#PivotTable');
<!DOCTYPE html>
<html lang="en">

<head>
    <title>EJ2 Pivot Grid</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta name="description" content="Typescript Pivot Grid Control" />
    <meta name="author" content="Syncfusion" />
    <link href="index.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-base/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-buttons/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-calendars/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-dropdowns/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-grids/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-charts/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-inputs/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-lists/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-navigations/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-popups/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-pivotview/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-splitbuttons/styles/material.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.38/system.js"></script>
    <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" />
    <script src="systemjs.config.js"></script>
<script src="https://cdn.syncfusion.com/ej2/syncfusion-helper.js" type ="text/javascript"></script>
</head>

<body>
    <div id='loader'>Loading....</div>
    <div id='container'>
        <div>
            <div id='PivotTable'></div>
        </div>
    </div>
</body>

</html>

In the above sample, Amount field is formatted by NumberFormatOptions. For date formats, the value strings are formatted by DateFormatOptions.

By default, locale value is en-US. If you want to change the en-US culture to a different culture, you have to change the locale accordingly.

Also, you will find more details about support format string for number formats and data formats here.

Decimal separators

The decimal separators of pivot table values varies based on the culture applied to the component. The culture can be set by calling the method setCulture with appropriate culture string as its parameter.

The following example demonstrates the decimal separators in Deutsch culture.

index.ts
index.html
import { loadCldr, L10n, setCulture, setCurrencyCode, Ajax } from '@syncfusion/ej2-base';
import * as currencies from './currencies.json';
import * as cagregorian from './ca-gregorian.json';
import * as numbers from './numbers.json';
import * as timeZoneNames from './timeZoneNames.json';
import * as numberingSystems from './numberingSystems.json';
import { PivotView, IDataSet, FieldList } from '@syncfusion/ej2-pivotview';
import { pivotData } from './datasource.ts';

loadCldr(currencies, cagregorian, numbers, timeZoneNames, numberingSystems);

setCulture('de');
setCurrencyCode('EUR');
loadCultureFiles();

L10n.load({
    'de-DE': {
        'pivotview': {
            'grandTotal': 'Gesamtsumme',
            'total': 'Insgesamt',
            'value': 'Wert',
            'noValue': 'Kein Wert',
            'row': 'Zeile',
            'column': 'Spalte',
            'collapse': 'Zusammenbruch',
            'expand': 'Erweitern'
        },
        "pivotfieldlist": {
            'fieldList': 'Feld Liste',
            'dropRowPrompt': 'Drop Reihe hier',
            'dropColPrompt': 'Drop column Hier',
            'dropValPrompt': 'Drop wert hier',
            'dropFilterPrompt': 'Drop Filter Hier',
            'addPrompt': 'Feld hinzufügen',
            'centerHeader': 'Ziehen Sie die Felder zwischen den Bereichen unten:',
            'add': 'Hinzufügen',
            'drag': 'Ziehen',
            'filters': 'Filter',
            'rows': 'Zeilen',
            'columns': 'Spalten',
            'values': 'Werte',
            'error': 'Fehler',
            'dropAction': 'Berechnetes Feld nicht in jeder anderen Region außer Wert Achse sein.',
            'search': 'Suche',
            'close': 'Schließen',
            'cancel': 'Abbrechen',
            'delete': 'Löschen',
            'alert': 'Warnung',
            'warning': 'Warnung',
            'ok': 'OK',
            'allFields': 'Alle Felder',
            'noMatches': 'Keine Treffer'
        }
    }
});

PivotView.Inject(FieldList);
let pivotTableObj: PivotView = new PivotView({
    dataSourceSettings: {
        dataSource: pivotData as IDataSet[],
        drilledMembers: [{ name: 'Country', items: ['France'] }],
        columns: [{ name: 'Year', caption: 'Production Year' }, { name: 'Quarter' }],
        values: [{ name: 'Sold', caption: 'Units Sold' }, { name: 'Amount', caption: 'Sold Amount' }],
        rows: [{ name: 'Country' }, { name: 'Products' }],
        formatSettings: [{ name: 'Amount', format: 'C2', currency: 'EUR' }],
        filters: []
    },
    locale: 'de-DE',
    showFieldList: true,
    height: 350
});
function loadCultureFiles() {
        var files = ['ca-gregorian.json', 'numbers.json', 'currencies.json', 'timeZoneNames.json', 'numberingSystems.json'];
        var loadCulture = function (prop: number) {
            var val, ajax;
            ajax = new Ajax('./' + files[prop], 'GET', false);
            ajax.onSuccess = function (value: any) {
                val = value;
            };
            ajax.send();
            loadCldr(JSON.parse(val));
        };
        for (var prop = 0; prop < files.length; prop++) {
            loadCulture(prop);
        }
}
pivotTableObj.appendTo('#PivotTable');
<!DOCTYPE html>
<html lang="en">

<head>
    <title>EJ2 Pivot Grid</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta name="description" content="Typescript Pivot Grid Control" />
    <meta name="author" content="Syncfusion" />
    <link href="index.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-base/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-buttons/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-calendars/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-dropdowns/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-grids/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-charts/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-inputs/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-lists/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-navigations/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-popups/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-pivotview/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-splitbuttons/styles/material.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.38/system.js"></script>
    <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" />
    <script src="systemjs.config.js"></script>
<script src="https://cdn.syncfusion.com/ej2/syncfusion-helper.js" type ="text/javascript"></script>
</head>

<body>
    <div id='loader'>Loading....</div>
    <div id='container'>
        <div>
            <div id='PivotTable'></div>
        </div>
    </div>
</body>

</html>

Localization

The Localization library allows you to localize default text content of the pivot table. The pivot table component has static text on some features (like drop area text, pivot field list title, etc…) that can be changed to other cultures (Arabic, Deutsch, French, etc.) by defining the
locale value and translation object.

The following list of properties and its values are used in the pivot table.

Locale keywords	Text
grandTotal	Grand Total
total	Total
value	Value
noValue	No value
row	Row
column	Column
collapse	Collapse
expand	Expand
rowAxisPrompt	Drop row here
columnAxisPrompt	Drop column here
valueAxisPrompt	Drop value here
filterAxisPrompt	Drop filter here
filter	Filter
filtered	Filtered
sort	Sort
filters	Filters
rows	Rows
columns	Columns
values	Values
close	Close
cancel	Cancel
delete	Delete
CalculatedField	Calculated Field
createCalculatedField	Create Calculated Field
fieldName	Enter the field name
error	Error
invalidFormula	Invalid formula.
dropText	Example: (‘Sum(Order_Count)’ + ‘Sum(In_Stock)’) * 250
dropTextMobile	Add fields and edit formula here.
dropAction	Calculated field cannot be place in any other region except value axis.
alert	Alert
warning	Warning
ok	OK
search	Search
drag	Drag
remove	Remove
Sum	Sum
Avg	Avg
Count	Count
Min	Min
Max	Max
allFields	All Fields
formula	Formula
addToRow	Add to Row
addToColumn	Add to Column
addToValue	Add to Value
addToFilter	Add to Filter
emptyData	No records to display
fieldExist	A field already exists in this name. Please enter a different name.
confirmText	A calculation field already exists in this name. Do you want to replace it?
noMatches	No matches
format	Summaries values by
edit	Edit
clear	Clear
formulaField	Drag and drop fields to formula
dragField	Drag field to formula
clearFilter	Clear
by	by
all	All
multipleItems	Multiple items
member	Member
label	Label
date	Date
enterValue	Enter value
chooseDate	Enter date
Before	Before
BeforeOrEqualTo	Before Or Equal To
After	After
AfterOrEqualTo	After Or Equal To
labelTextContent	Show the items for which the label
dateTextContent	Show the items for which the date
valueTextContent	Show the items for which
Equals	Equals
DoesNotEquals	Does Not Equal
BeginWith	Begins With
DoesNotBeginWith	Does Not Begin With
EndsWith	Ends With
DoesNotEndsWith	Does Not End With
Contains	Contains
DoesNotContains	Does Not Contain
GreaterThan	Greater Than
GreaterThanOrEqualTo	Greater Than Or Equal To
LessThan	Less Than
LessThanOrEqualTo	Less Than Or Equal To
Between	Between
NotBetween	Not Between
And	and
DistinctCount	Distinct Count
Product	Product
SampleVar	Sample Var
PopulationVar	Population Var
RunningTotals	Running Totals
Index	Index
SampleStDev	Sample StDev
PopulationStDev	Population StDev
PercentageOfRowTotal	% of Row Total
PercentageOfParentTotal	% of Parent Total
PercentageOfParentColumnTotal	% of Parent Column Total
PercentageOfParentRowTotal	% of Parent Row Total
DifferenceFrom	Difference From
PercentageOfDifferenceFrom	% of Difference From
PercentageOfGrandTotal	% of Grand Total
PercentageOfColumnTotal	% of Column Total
NotEquals	Not Equals
AllValues	All Values
conditionalFormatting	Conditional Formatting
apply	APPLY
condition	Add Condition
formatLabel	Format
valueFieldSettings	Value field settings
baseField	Base field :
baseItem	Base item :
summarizeValuesBy	Summarize values by :
sourceName	Field name :
sourceCaption	Field caption :
example	e.g:
editorDataLimitMsg	more items. Search to refine further.
details	Details
manageRecords	Manage Records
Years	Years
Quarters	Quarters
Months	Months
Days	Days
Hours	Hours
Minutes	Minutes
Seconds	Seconds
save	Save a report
new	Create a new report
load	Load
saveAs	Save as current report
rename	Rename a current report
deleteReport	Delete a current report
export	Export
subTotals	Sub totals
grandTotals	Grand totals
reportName	Report Name :
pdf	PDF
excel	Excel
csv	CSV
png	PNG
jpeg	JPEG
svg	SVG
mdxQuery	MDX Query
showSubTotals	Show subtotals
doNotShowSubTotals	Do not show subtotals
showSubTotalsRowsOnly	Show subtotals rows only
showSubTotalsColumnsOnly	Show subtotals columns only
showGrandTotals	Show grand totals
doNotShowGrandTotals	Do not show grand totals
showGrandTotalsRowsOnly	Show grand totals rows only
showGrandTotalsColumnsOnly	Show grand totals columns only
fieldList	Show fieldlist
grid	Show table
toolbarFormatting	Conditional formatting
chart	Chart
reportMsg	Please enter valid report name!!!
reportList	Report list
removeConfirm	Are you sure want to delete this report?
emptyReport	No reports found!!
bar	Bar
line	Line
area	Area
scatter	Scatter
polar	Polar
of	of
emptyFormat	No format found!!!
emptyInput	Enter a value
newReportConfirm	Want to save changes to report?
emptyReportName	Enter a report name
qtr	Qtr
null	null
undefined	undefined
groupOutOfRange	Out of Range
fieldDropErrorAction	The field you are moving cannot be placed in that area of the report
MoreOption	More…
aggregate	Aggregate
drillThrough	Drill Through
ascending	Ascending
descending	Descending
number	Number
currency	Currency
percentage	Percentage
formatType	Format Type
customText	Currency Symbol
symbolPosition	Symbol Position
left	Left
right	Right
grouping	Grouping
true	True
false	False
decimalPlaces	Decimal Places
numberFormat	Number Formatting
memberType	Field Type
formatString	Format String
expressionField	Expression
customFormat	Enter custom format string
selectedHierarchy	Parent Hierarchy
olapDropText	Example: [Measures].[Order Quantity] + ([Measures].[Order Quantity] * 0.10)
Percent	Percent
Custom	Custom
Measure	Measure
Dimension	Dimension
Standard	Standard
blank	(Blank)
fieldTooltip	Drag and drop fields to create an expression. And, if you want to edit the existing the calculated fields! Then you can achieve it by simply selecting the field under ‘Calculated Members’.
QuarterYear	Quarter Year
fieldTitle	Field Name
drillError	Cannot show the raw items of calculated fields.
caption	Field Caption
copy	Copy
defaultReport	Default report
customFormatString	Custom Format
invalidFormat	Invalid Format.
group	Group
unGroup	Ungroup
invalidSelection	Cannot group that selection.
groupName	Enter the caption to display in header
captionName	Enter the caption for group field
selectedItems	Selected items
groupFieldCaption	Field caption
groupTitle	Group name
startAt	Starting at
endAt	Ending at
groupBy	Interval by
selectGroup	Select groups
numberFormatString	Example: C, P, 0000 %, ###0.##0#, etc.
stackingcolumn	Stacked Column
stackingbar	Stacked Bar
stackingarea	Stacked Area
stepline	Step Line
steparea	Step Area
splinearea	Spline Area
spline	Spline
stackingcolumn100	100% Stacked Column
stackingbar100	100% Stacked Bar
stackingarea100	100% Stacked Area
bubble	bubble
pareto	Pareto
radar	Radar
chartTypeSettings	Chart type settings
multipleAxes	Multiple Axes
sortAscending	Sort ascending order
sortDescending	Sort descending order
sortNone	Sort data order
clearCalculatedField	Clear edited field info
editCalculatedField	Edit calculated field
ChartType	Chart Type
yes	Yes
no	No
numberFormatMenu	Number Formatting…
conditionalFormattingMenu	Conditional Formatting…
removeCalculatedField	Are you sure you want to delete this calculated field?
replaceConfirmBefore	A report named
replaceConfirmAfter	already exists. Do you want to replace it?
pie	Pie
funnel	Funnel
doughnut	Doughnut
pyramid	Pyramid
showLegend	Show Legend
exit	Exit
invalidJSON	Invalid JSON data
invalidCSV	Invalid CSV data
stacked	Stacked
single	Single
multipleAxisMode	Multiple Axis Mode
grandTotalPosition	Grand totals position
top	Top
bottom	Bottom
None	None
stackingline	Stacked Line
stackingline100	100% Stacked Line
rowPage	Row pager
rowPerPage	Rows per page
columnPage	Column pager
columnPerPage	Columns per page
goToFirstPage	Go to first page
goToPreviousPage	Go to previous page
goToNextPage	Go to next page
goToLastPage	Go to last page
combined	Combined
subTotalPosition	Subtotals position
auto	Auto

The following list of properties and its values are used in the pivot field list.

Locale keywords	Text
staticFieldList	Pivot Field List
fieldList	Field List
dropFilterPrompt	Drop filter here
dropColPrompt	Drop column here
dropRowPrompt	Drop row here
dropValPrompt	Drop value here
addPrompt	Add field here
adaptiveFieldHeader	Choose field
centerHeader	Drag fields between axes below:
add	add
drag	Drag
filter	Filter
filtered	Filtered
sort	Sort
remove	Remove
filters	Filters
rows	Rows
columns	Columns
values	Values
CalculatedField	Calculated Field
createCalculatedField	Create Calculated Field
fieldName	Enter the field name
error	Error
invalidFormula	Invalid formula.
dropText	Example: (‘Sum(Order_Count)’ + ‘Sum(In_Stock)’) * 250
dropTextMobile	Add fields and edit formula here.
dropAction	Calculated field cannot be place in any other region except value axis.
search	Search
close	Close
cancel	Cancel
delete	Delete
alert	Alert
warning	Warning
ok	OK
Sum	Sum
Avg	Avg
Count	Count
Min	Min
Max	Max
allFields	All Fields
formula	Formula
fieldExist	A field already exists in this name. Please enter a different name.
confirmText	A calculation field already exists in this name. Do you want to replace it?
noMatches	No matches
format	Summaries values by
edit	Edit
clear	Clear
formulaField	Drag and drop fields to formula
dragField	Drag field to formula
clearFilter	Clear
by	by
enterValue	Enter value
chooseDate	Enter date
all	All
multipleItems	Multiple items
Equals	Equals
DoesNotEquals	Does Not Equal
BeginWith	Begins With
DoesNotBeginWith	Does Not Begin With
EndsWith	Ends With
DoesNotEndsWith	Does Not End With
Contains	Contains
DoesNotContains	Does Not Contain
GreaterThan	Greater Than
GreaterThanOrEqualTo	Greater Than Or Equal To
LessThan	Less Than
LessThanOrEqualTo	Less Than Or Equal To
Between	Between
NotBetween	Not Between
Before	Before
BeforeOrEqualTo	Before Or Equal To
After	After
AfterOrEqualTo	After Or Equal To
member	Member
label	Label
date	Date
value	Value
labelTextContent	Show the items for which the label
dateTextContent	Show the items for which the date
valueTextContent	Show the items for which
And	and
DistinctCount	Distinct Count
Product	Product
Index	Index
SampleStDev	Sample StDev
PopulationStDev	Population StDev
SampleVar	Sample Var
PopulationVar	Population Var
RunningTotals	Running Totals
DifferenceFrom	Difference From
PercentageOfDifferenceFrom	% of Difference From
PercentageOfGrandTotal	% of Grand Total
PercentageOfColumnTotal	% of Column Total
PercentageOfRowTotal	% of Row Total
PercentageOfParentTotal	% of Parent Total
PercentageOfParentColumnTotal	% of Parent Column Total
PercentageOfParentRowTotal	% of Parent Row Total
Years	Years
Quarters	Quarters
Months	Months
Days	Days
Hours	Hours
Minutes	Minutes
Seconds	Seconds
apply	APPLY
valueFieldSettings	Value field settings
sourceName	Field name :
sourceCaption	Field caption :
summarizeValuesBy	Summarize values by :
baseField	Base field :
baseItem	Base item :
example	e.g:
editorDataLimitMsg	more items. Search to refine further.
deferLayoutUpdate	Defer Layout Update
null	null
undefined	undefined
groupOutOfRange	Out of Range
fieldDropErrorAction	The field you are moving cannot be placed in that area of the report
MoreOption	More…
memberType	Field Type
selectedHierarchy	Parent Hierarchy
formatString	Format String
expressionField	Expression
olapDropText	Example: [Measures].[Order Quantity] + ([Measures].[Order Quantity] * 0.10)
customFormat	Enter custom format string
Measure	Measure
Dimension	Dimension
Standard	Standard
Currency	Currency
Percent	Percent
Custom	Custom
blank	(Blank)
fieldTooltip	Drag and drop fields to create an expression. And, if you want to edit the existing the calculated fields! You can achieve it by simply selecting the field under ‘Calculated Members’.
fieldTitle	Field Name
QuarterYear	Quarter Year
caption	Field Caption
copy	Copy
group	Group
numberFormatString	Example: C, P, 0000 %, ###0.##0#, etc.
sortAscending	Sort ascending order
sortDescending	Sort descending order
sortNone	Sort data order
clearCalculatedField	Clear edited field info
editCalculatedField	Edit calculated field
selectGroup	Select groups
of	of
removeCalculatedField	Are you sure you want to delete this calculated field?
yes	Yes
no	No
None	None

NOTE

To find the latest localization keywords of pivotview and pivotfieldlist for different languages, visit this GitHub repository.

Loading Translations

To load translation object in an application, use load function of the L10n class.

The following example demonstrates the pivot table in Deutsch culture.

index.ts
index.html
import { L10n } from '@syncfusion/ej2-base';
import { PivotView, IDataSet, FieldList } from '@syncfusion/ej2-pivotview';
import { pivotData } from './datasource.ts';

L10n.load({
    'de-DE': {
        'pivotview': {
            'grandTotal': 'Gesamtsumme',
            'total': 'Insgesamt',
            'value': 'Wert',
            'noValue': 'Kein Wert',
            'row': 'Zeile',
            'column': 'Spalte',
            'collapse': 'Zusammenbruch',
            'expand': 'Erweitern'
        },
        "pivotfieldlist": {
            'fieldList': 'Feld Liste',
            'dropRowPrompt': 'Drop Reihe hier',
            'dropColPrompt': 'Drop column Hier',
            'dropValPrompt': 'Drop wert hier',
            'dropFilterPrompt': 'Drop Filter Hier',
            'addPrompt': 'Feld hinzufügen',
            'centerHeader': 'Ziehen Sie die Felder zwischen den Bereichen unten:',
            'add': 'Hinzufügen',
            'drag': 'Ziehen',
            'filters': 'Filter',
            'rows': 'Zeilen',
            'columns': 'Spalten',
            'values': 'Werte',
            'error': 'Fehler',
            'dropAction': 'Berechnetes Feld nicht in jeder anderen Region außer Wert Achse sein.',
            'search': 'Suche',
            'close': 'Schließen',
            'cancel': 'Abbrechen',
            'delete': 'Löschen',
            'alert': 'Warnung',
            'warning': 'Warnung',
            'ok': 'OK',
            'allFields': 'Alle Felder',
            'noMatches': 'Keine Treffer'
        }
    }
});

PivotView.Inject(FieldList);
let pivotTableObj: PivotView = new PivotView({
    dataSourceSettings: {
        dataSource: pivotData as IDataSet[],
        expandAll: false,
        enableSorting: true,
        drilledMembers: [{ name: 'Country', items: ['France'] }],
        columns: [{ name: 'Year', caption: 'Production Year' }, { name: 'Quarter' }],
        values: [{ name: 'Sold', caption: 'Units Sold' }, { name: 'Amount', caption: 'Sold Amount' }],
        rows: [{ name: 'Country' }, { name: 'Products' }],
        formatSettings: [{ name: 'Amount', format: 'C0' }],
        filters: []
    },
    locale: 'de-DE',
    showFieldList: true,
    height: 350
});
pivotTableObj.appendTo('#PivotTable');
<!DOCTYPE html>
<html lang="en">

<head>
    <title>EJ2 Pivot Grid</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta name="description" content="Typescript Pivot Grid Control" />
    <meta name="author" content="Syncfusion" />
    <link href="index.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-base/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-buttons/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-calendars/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-dropdowns/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-grids/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-charts/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-inputs/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-lists/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-navigations/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-popups/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-pivotview/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-splitbuttons/styles/material.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.38/system.js"></script>
    <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" />
    <script src="systemjs.config.js"></script>
<script src="https://cdn.syncfusion.com/ej2/syncfusion-helper.js" type ="text/javascript"></script>
</head>

<body>
    <div id='loader'>Loading....</div>
    <div id='container'>
        <div>
            <div id='PivotTable'></div>
        </div>
    </div>
</body>

</html>

Right-to-left (RTL)

RTL provides an option to switch the text direction and layout of the pivot table component from right to left. It improves the user experiences and accessibility for users who use right-to-left languages (Arabic, Farsi, Urdu, etc…). To enable RTL pivot table, set the enableRtl property to true.

index.ts
index.html
import { L10n } from '@syncfusion/ej2-base';
import { PivotView, IDataSet, FieldList } from '@syncfusion/ej2-pivotview';
import { pivotData } from './datasource.ts';

L10n.load({
    'ar-AE': {
        'pivotview': {
            'grandTotal': 'المجموع الكلى',
            'total': 'المجموع',
            'value': 'القيمة',
            'noValue': 'لا قيمة لها',
            'row': 'صف',
            'column': 'العمود',
            'collapse': 'الانهيار',
            'expand': 'توسيع'
        },
        'pivotfieldlist': {
            'fieldList': 'قائمة الحقول',
            'dropRowPrompt': 'تراجع الخلاف هنا',
            'dropColPrompt': 'انخفاض العمود هنا',
            'dropValPrompt': 'انخفاض قيمة هنا',
            'dropFilterPrompt': 'انخفاض هنا عامل التصفية',
            'addPrompt': 'اضافة حقل هنا',
            'adaptiveFieldHeader': 'اختر الحقل',
            'centerHeader': 'اسحب المجالات بين المناطق الموضحة ادناه:',
            'add': 'اضافة',
            'drag': 'اسحب',
            'filters': 'عوامل التصفية',
            'rows': 'الصفوف',
            'columns': 'الاعمدة',
            'values': 'قيم',
            'search': 'البحث',
            'close': 'قريب',
            'cancel': 'الغاء',
            'delete': 'احذف',
            'alert': 'حالة تاهب قصوى',
            'warning': 'تحذير',
            'ok': 'موافق',
            'allFields': 'جميع الحقول',
            'noMatches': 'لا مباريات'
        }
    }
});

PivotView.Inject(FieldList);
let pivotTableObj: PivotView = new PivotView({
        dataSourceSettings: {
        dataSource: pivotData as IDataSet[],
        expandAll: false,
        enableSorting: true,
        drilledMembers: [{ name: 'Country', items: ['France'] }],
        columns: [{ name: 'Year', caption: 'Production Year' }, { name: 'Quarter' }],
        values: [{ name: 'Sold', caption: 'Units Sold' }, { name: 'Amount', caption: 'Sold Amount' }],
        rows: [{ name: 'Country' }, { name: 'Products' }],
        formatSettings: [{ name: 'Amount', format: 'C0' }],
        filters: []
    },
    enableRtl: true,
    locale: 'ar-AE',
    showFieldList: true,
    height: 350
});
pivotTableObj.appendTo('#PivotTable');
<!DOCTYPE html>
<html lang="en">

<head>
    <title>EJ2 Pivot Grid</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta name="description" content="Typescript Pivot Grid Control" />
    <meta name="author" content="Syncfusion" />
    <link href="index.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-base/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-buttons/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-calendars/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-dropdowns/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-grids/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-charts/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-inputs/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-lists/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-navigations/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-popups/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-pivotview/styles/material.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/27.2.2/ej2-splitbuttons/styles/material.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.38/system.js"></script>
    <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" />
    <script src="systemjs.config.js"></script>
<script src="https://cdn.syncfusion.com/ej2/syncfusion-helper.js" type ="text/javascript"></script>
</head>

<body>
    <div id='loader'>Loading....</div>
    <div id='container'>
        <div>
            <div id='PivotTable'></div>
        </div>
    </div>
</body>

</html>