Controls Documentation
Document Processing Libraries
knowledge-base
API Reference
Controls / RadPivotGrid / Features / Localization
New to Telerik UI for WPF? Start a free 30-day trial

Localization

Updated on Sep 24, 2025

The built-in localization mechanism in WPF allows you to localize any string resource used by RadPivotGrid and RadPivotFieldList controls. Once translated you might use the resources in your projects without changing anything. You can find more information on the localization of the UI here.

The LocalDataSourceProvider provides an additional Culture support option which allows you to localize the underlying data using any desired Culture. For more details please check the Culture Support article from the LocalDataSourceProvider section.

Supported Languages

RadPivotGrid can be translated in one of the following supported languages using the framework’s localization mechanism:

  • English
  • German
  • Spanish
  • French
  • Italian
  • Dutch
  • Turkish

More information on how to achieve this you can find in the Localization Using Built-in Resources article.

Localization Using Custom Localization Manager

Telerik.Windows.Controls.LocalizationManager allows you to easily localize any of the Telerik controls. To apply custom localization to your controls just instantiate your custom LocalizationManager and set it to the static property LocalizationManager.Manager, before the creation of the UI:

C#
	LocalizationManager.Manager = new CustomLocalizationManager();
	InitializeComponent();

CustomLocalizationManager must inherit LocalizationManager and override its GetStringOverride method. Here is an implementation of a custom localization:

C#
	public class CustomLocalizationManager : LocalizationManager
	{
	    private IDictionary<string, string> dictionary;
	
	    public CustomLocalizationManager()
	    {
	        this.dictionary = new Dictionary<string, string>();
	
	        this.dictionary["Pivot_Row"] = "Row";
	        this.dictionary["Pivot_Column"] = "Column";
	        this.dictionary["Pivot_Value"] = "Value: {0}";
	
	        this.dictionary["PivotFieldList_ShowItemsForWhichTheLabel"] = "Show items for which the label";
	        this.dictionary["PivotFieldList_And"] = "and";
	        this.dictionary["PivotFieldList_AscendingBy"] = "Ascending (A to Z) by:";
	        this.dictionary["PivotFieldList_BaseField"] = "Base field:";
	        this.dictionary["PivotFieldList_BaseItem"] = "Base item:";
	        this.dictionary["PivotFieldList_By"] = "by:";
	        this.dictionary["PivotFieldList_ChooseAggregateFunction"] = "Choose the type of calculation that you want to use to summarize data from the selected field.";
	        this.dictionary["PivotFieldList_ChooseFieldsToAddToReport"] = "Choose fields to add to report:";
	        this.dictionary["PivotFieldList_ColumnLabels"] = "Column Labels";
	        this.dictionary["PivotFieldList_DeferLayoutUpdate"] = "Defer Layout Update";
	        this.dictionary["PivotFieldList_DescendingBy"] = "Descending (Z to A) by:";
	        this.dictionary["PivotFieldList_DragFieldsBetweenAreasBelow"] = "Drag fields between areas below:";
	        this.dictionary["PivotFieldList_Format"] = "Format:";
	        this.dictionary["PivotFieldList_GeneralFormat"] = "General Format";
	        this.dictionary["PivotFieldList_IgnoreCase"] = "Ignore Case";
	        this.dictionary["PivotFieldList_PleaseRefreshThePivot"] = "Please refresh the pivot.";
	        this.dictionary["PivotFieldList_Refresh"] = "Refresh";
	        this.dictionary["PivotFieldList_ReportFilter"] = "Report Filter";
	        this.dictionary["PivotFieldList_RowLabels"] = "Row Labels";
		this.dictionary["PivotFieldList_Search"] = "Search";
		this.dictionary["PivotFieldList_NoResult"] = "No Result";
	        this.dictionary["PivotFieldList_SelectItem"] = "Select Item";
	        this.dictionary["PivotFieldList_Show"] = "Show";
	        this.dictionary["PivotFieldList_ShowItemsForWhich"] = "PivotFieldList_ShowItemsForWhich";
	        this.dictionary["PivotFieldList_ShowValuesAs"] = "Show Values As";
	        this.dictionary["PivotFieldList_SortOptions"] = "Sort options";
	        this.dictionary["PivotFieldList_StringFormatDescription"] = "The format should identify the measurement type of the value. The format would be used for general computations such as Sum, Average, Min, Max and others.";
	        this.dictionary["PivotFieldList_SummarizeValuesBy"] = "Summarize Values By";
	        this.dictionary["PivotFieldList_TheActionRequiresMoreRecentInformation"] = "The action requires more recent information.";
	        this.dictionary["PivotFieldList_Update"] = "Update";
	        this.dictionary["PivotFiledList_Values"] = "Values";
	
	        this.dictionary["Ok"] = "Ok";
	        this.dictionary["Cancel"] = "Cancel";
	
	        this.dictionary["PivotFieldList_SetSumAggregate"] = "Sum";
	        this.dictionary["PivotFieldList_SetCountAggregate"] = "Count";
	        this.dictionary["PivotFieldList_SetAverageAggregate"] = "Average";
	        this.dictionary["PivotFieldList_SetIndexTotalFormat"] = "Index";
	        this.dictionary["PivotFieldList_SetPercentOfGrandTotalFormat"] = "% of Grand Total";
	        this.dictionary["PivotFieldList_SortAtoZ"] = "Sort A to Z";
	        this.dictionary["PivotFieldList_SortZtoA"] = "Sort Z to A";
	        this.dictionary["PivotFieldList_MoreSortingOptions"] = "More Sorting Options...";
	        this.dictionary["PivotFieldList_LabelFilter"] = "Label Filter";
	        this.dictionary["PivotFieldList_ValueFilter"] = "Value Filter";
	        this.dictionary["PivotFieldList_TopTenFilter"] = "Top 10 Filter";
	        this.dictionary["PivotFieldList_ClearFilter"] = "Clear Filter";
	        this.dictionary["PivotFieldList_ShowEmptyGroups"] = "Show Empty Groups";
			this.dictionary["PivotFieldList_ShowSubTotals "] = "Show Subtotals";
	        this.dictionary["PivotFieldList_SelectItems"] = "Select Items";
	        this.dictionary["PivotFieldList_MoreAggregateOptions"] = "More Aggregate Options...";
	        this.dictionary["PivotFieldList_MoreCalculationOptions"] = "More Calculation Options...";
	        this.dictionary["PivotFieldList_ClearCalculations"] = "Clear Calculations";
	        this.dictionary["PivotFieldList_NumberFormat"] = "Number Format";
	
	        this.dictionary["Pivot_GrandTotal"] = "Grand Total";
	        this.dictionary["Pivot_Values"] = "Values";
	        this.dictionary["Pivot_Error"] = "Error";
	        this.dictionary["Pivot_TotalP0"] = "Total {0}";
	        this.dictionary["Pivot_P0Total"] = "{0} Total";
	
	        this.dictionary["Pivot_GroupP0AggregateP1"] = "{0} {1}";
	
	        this.dictionary["Pivot_AggregateP0ofP1"] = "{0} of {1}";
	
	        this.dictionary["Pivot_AggregateSum"] = "Sum";
	        this.dictionary["Pivot_AggregateCount"] = "Count";
	        this.dictionary["Pivot_AggregateAverage"] = "Average";
	        this.dictionary["Pivot_AggregateMin"] = "Min";
	        this.dictionary["Pivot_AggregateMax"] = "Max";
	        this.dictionary["Pivot_AggregateProduct"] = "Product";
	        this.dictionary["Pivot_AggregateVar"] = "Var";
	        this.dictionary["Pivot_AggregateVarP"] = "VarP";
	        this.dictionary["Pivot_AggregateStdDev"] = "StdDev";
	        this.dictionary["Pivot_AggregateStdDevP"] = "StdDevP";
	        this.dictionary["Pivot_HourGroup"] = "{0} - Hour";
	        this.dictionary["Pivot_MinuteGroup"] = "{0} - Minute";
	        this.dictionary["Pivot_MonthGroup"] = "{0} - Month";
	        this.dictionary["Pivot_QuarterGroup"] = "{0} - Quarter";
	        this.dictionary["Pivot_SecondGroup"] = "{0} - Second";
	        this.dictionary["Pivot_WeekGroup"] = "{0} - Week";
	        this.dictionary["Pivot_YearGroup"] = "{0} - Year";
	        this.dictionary["Pivot_DayGroup"] = "{0} - Day";
	        this.dictionary["PivotFieldList_PercentOfColumnTotal"] = "% of Column Total";
	        this.dictionary["PivotFieldList_PercentOfRowTotal"] = "% of Row Total";
	        this.dictionary["PivotFieldList_PercentOfGrandTotal"] = "% of Grand Total";
	        this.dictionary["PivotFieldList_NoCalculation"] = "No Calculation";
	        this.dictionary["PivotFieldList_DifferenceFrom"] = "Difference From";
	        this.dictionary["PivotFieldList_PercentDifferenceFrom"] = "% Difference From";
	        this.dictionary["PivotFieldList_PercentOf"] = "% Of";
	        this.dictionary["PivotFieldList_RankSmallestToLargest"] = "Rank Smallest to Largest";
	        this.dictionary["PivotFieldList_RankLargestToSmallest"] = "Rank Largest to Smallest";
	        this.dictionary["PivotFieldList_PercentRunningTotalIn"] = "% Running Total In";
	        this.dictionary["PivotFieldList_RunningTotalIn"] = "Running Total In";
	        this.dictionary["PivotFieldList_Index"] = "Index";
	
	        this.dictionary["PivotFieldList_RelativeToPrevious"] = "(previous)";
	        this.dictionary["PivotFieldList_RelativeToNext"] = "(next)";
	
	        this.dictionary["PivotFieldList_ConditionEquals"] = "equals";
	        this.dictionary["PivotFieldList_DoesNotEqual"] = "does not equal";
	        this.dictionary["PivotFieldList_IsGreaterThan"] = "is greater than";
	        this.dictionary["PivotFieldList_IsGreaterThanOrEqualTo"] = "is greater than or equal to";
	        this.dictionary["PivotFieldList_IsLessThan"] = "is less than";
	        this.dictionary["PivotFieldList_IsLessThanOrEqualTo"] = "is less than or equal to";
	        this.dictionary["PivotFieldList_BeginsWith"] = "begins with";
	        this.dictionary["PivotFieldList_DoesNotBeginWith"] = "does not begin with";
	        this.dictionary["PivotFieldList_EndsWith"] = "ends with";
	        this.dictionary["PivotFieldList_DoesNotEndWith"] = "does not end with";
	        this.dictionary["PivotFieldList_Contains"] = "contains";
	        this.dictionary["PivotFieldList_DoesNotContains"] = "does not contain";
	        this.dictionary["PivotFieldList_IsBetween"] = "is between";
	        this.dictionary["PivotFieldList_IsNotBetween"] = "is not between";
	
	        this.dictionary["PivotFieldList_SelectAll"] = "(Select All)";
	
	        this.dictionary["PivotFieldList_Top10Items"] = "Items";
	        this.dictionary["PivotFieldList_Top10Percent"] = "Percent";
	        this.dictionary["PivotFieldList_Top10Sum"] = "Sum";
	
	        this.dictionary["PivotFieldList_TopItems"] = "Top";
	        this.dictionary["PivotFieldList_BottomItems"] = "Bottom";
	
	        this.dictionary["PivotFieldList_FilterItemsP0"] = "Fitler Items ({0})";
	        this.dictionary["PivotFieldList_LabelFilterP0"] = "Label Filter ({0})";
	        this.dictionary["PivotFieldList_SortP0"] = "Sort ({0})";
	        this.dictionary["PivotFieldList_FormatCellsP0"] = "Format Cells ({0})";
	        this.dictionary["PivotFieldList_ValueSummarizationP0"] = "Value Summarization ({0})";
	        this.dictionary["PivotFieldList_Top10FilterP0"] = "Top10 Filter ({0})";
	        this.dictionary["PivotFieldList_ShowValuesAsP0"] = "Show Values As ({0})";
	        this.dictionary["PivotFieldList_ValueFilterP0"] = "Value Filter ({0})";
	        this.dictionary["PivotFieldList_Null"] = "(null)";
	
	        this.dictionary["Pivot_CalculatedFields"] = "Calculated Fields";
	        this.dictionary["PivotFieldList_ItemFilterConditionCaption"] = "Show items with value that";
	        this.dictionary["PivotFieldList_None"] = "Data source order";
	        this.dictionary["PivotFieldList_Sort_BySortKeys"] = "by Sort Keys";
	    }
	
	    public override string GetStringOverride(string key)
	    {
	        string localized;
	
	        if (this.dictionary.TryGetValue(key, out localized))
	        {
	            return localized;
	        }
	        else
	        {
	            return base.GetStringOverride(key);
	        }
	    }
	}

As you can see, there are a lot of keys that have to be localized. In the table below you can find more information about each of them.

In the code above there are two keys, that will reflect not only RadPivotGrid, but all buttons in your applications. These are the resources with keys "Ok" and "Cancel".

KeyEnglish Value of the KeyComment
Pivot_AggregateAverageAverageAverage aggregate function. Example: Average of Quantity
Pivot_AggregateCountCountCount aggregate function. Example: Count of Products
Pivot_AggregateMaxMaxMax aggregate function. Example: Max of Net
Pivot_AggregateMinMinMin aggregate function. Example: Min of Net
Pivot_AggregateProductProductProduct aggregate function. Example: Product of Quantity
Pivot_AggregateStdDevStdDevSample Standard Deviation aggregate function. Example: StdDev of Net
Pivot_AggregateStdDevPStdDevPPopulation Standard Deviation aggregate function. Example: StdDevP of Net
Pivot_AggregateSumSumSum aggregate function. Example: Sum of Net
Pivot_AggregateVarVarSimple Variance aggregate function. Example: Var of Net
Pivot_AggregateVarPVarPPopulation Variance aggregate function. Example: VarP of Net
Pivot_AggregateP0ofP1{0} of {1}When you apply aggregate function for a specific property, RadPivotGrid and RadPivotFieldList show similar string: Sum of Quantity. This key will help you to localize such strings and particularly the "of" part. In the common scenario you should have {0} to show the aggregate function, your string that will replace the "of" part and {1} for property name.
Pivot_ColumnColumnUsed in tooltip to mark the Column in which is the current value.
Pivot_GrandTotalGrand TotalUsed in RadPivotGrid as the header of the row/column showing the Grand Totals of the aggregation.
Pivot_GroupP0AggregateP1{0} {1}Used in RadPivotGrid as header of the rows/columns, which is showing SubTotal when there are more than one aggregate description. {0} parameter is replaced by items name, while {1} parameter is replaced by Pivot_AggregateP0ofP1 value. Example: For the {0}='Copy Holder' group, the aggregated {1}='Sum of Quantity' it will format the aggregate group name as Copy Holder Sum of Quantity
Pivot_P0Total{0} TotalUsed in RadPivotGrid as header of the row/column, which is showing SubTotals. The {0} parameter is replaced by group name. Example: Newspaper Total
Pivot_RowRowUsed in tooltip to mark the Row in which is the current value.
Pivot_TotalP0Total {0}Used in RadPivotGrid as header of the row/column, which is showing the Totals for each of the aggregate description when there are more than one. If AggregatesPosition property of RadPivotGrid is set to "Rows", than the last rows in RadPivotGrid will show the "Totals" for each of the aggregate descriptions. The headers of these last rows can be modified with this key. {0} is replaced by Pivot_AggregateP0ofP1 value. Example: Total Sum of Quantity
Pivot_ValueValue: {0}Used in tooltip to mark the Value of the current cell.
Pivot_ValuesValuesUsed in the tooltip, when there are more than one aggregate descriptions, to describe the special "Values" group that is created (you can see it in rows/columns in RadPivotFieldList).
Pivot_ErrorErrorUsed in RadPivotGrid to mark that the value in the cell is not correct. You may see this string when the property which you are trying to aggregate is not a number, when there is division with 0, etc.
PivotFieldList_AndandUsed in RadPivotFieldList dialogs. Example: between 10 and 20
PivotFieldList_AscendingByAscending (A to Z) by:Used in RadPivotFieldList buttons and dialogs for ascending sorting. Example: Sort Ascending (A to Z) by
PivotFieldList_BaseFieldBase field:Used in the calculations dialog of RadPivotFieldList. It stays as a Label of the ListBox in which you are able to select the group description by which the calculation will be applied.
PivotFieldList_BaseItemBase item:Used in the calculations dialog of RadPivotFieldList. It stays as a Label of the ListBox in which you are able to select the group by which the calculation will be applied.
PivotFieldList_BeginsWithbegins withUsed in the label filter dialog of RadPivotFieldList. It indicates that only groups that "begins with" string that is typed in the nearby TextBox will be displayed.
PivotFieldList_BottomItemsBottomUsed in the Top 10 Filter dialog of RadPivotFieldList. It indicates that the "last" items matching specified conditions, will be displayed.
PivotFieldList_BybyUsed in Top 10 Filter dialog of RadPivotFieldList. In this dialog there are several options to choose how to apply the filter and this key provides value for a TextBlock, that will display by which aggregate the filter will be applied. Example: Top 10 items by Sum of Quantity
PivotFieldList_ChooseAggregateFunctionChoose the type of calculation that you want to use to summarize data from the selected field.Used in RadPivotFieldList calculations dialog. It explains the function of the dialog.
PivotFieldList_ChooseFieldsToAddToReportChoose fields to add to report:Used at the top part of RadPivotFieldList as a Header describing what to do with below fields.
PivotFieldList_ClearCalculationsClear CalculationsUsed in drop-down menus of the buttons in RadPivotFieldList. It is shown only after calculation is applied and when you click it, the calculation is cleared.
PivotFieldList_ClearFilterClear FilterUsed in drop-down menus of the buttons in RadPivotFieldList. It is shown only after group filter is applied and when you click it, the filter is cleared.
PivotFieldList_ColumnLabelsColumn LabelsUsed in RadPivotFieldList as a header of the box, showing ColumnGroupDescriptions.
PivotFieldList_ConditionEqualsequalsUsed in RadPivotFieldList filter dialogs to mark that only items, that have equal value with the one entered in the TextBox nearby, will be shown.
PivotFieldList_ContainscontainsUsed in RadPivotFieldList filter dialogs to mark that only items, that contain value with the one entered in the TextBox nearby, will be shown.
PivotFieldList_DeferLayoutUpdateDefer Layout UpdateUsed in the below part of RadPivotFieldList as a Checkbox by which you can enable defer of update and nearby button.
PivotFieldList_DescendingByDescending (Z to A) by:Used in RadPivotFieldList buttons and dialogs for ascending sorting. Example: Sort Descending (A to Z) by
PivotFieldList_DifferenceFromDifference FromUsed in the calculation dialog of RadPivotFieldList. It marks that RadPivotGrid must show the values as a difference from a specific group selected in the other ListBox.
PivotFieldList_DoesNotBeginWithdoes not begin withUsed in RadPivotFieldList filter dialogs to mark that only items, that does not begin with the value entered in the TextBox nearby, will be shown.
PivotFieldList_DoesNotContainsdoes not containUsed in RadPivotFieldList filter dialogs to mark that only items, that does not contain the value entered in the TextBox nearby, will be shown.
PivotFieldList_DoesNotEndWithdoes not end withUsed in RadPivotFieldList filter dialogs to mark that only items, that does not end with the value entered in the TextBox nearby, will be shown.
PivotFieldList_DoesNotEqualdoes not equalUsed in RadPivotFieldList filter dialogs to mark that only items, that are not equal with the value entered in the TextBox nearby, will be shown.
PivotFieldList_DragFieldsBetweenAreasBelowDrag fields between areas below:Used in the middle of RadPivotFieldList to explain how to move items between areas below.
PivotFieldList_EndsWithends withUsed in RadPivotFieldList filter dialogs to mark that only items, that are ends with the value entered in the TextBox nearby, will be shown.
PivotFieldList_FilterItemsP0Filter Items ({0})Used in Report Filter dialog of RadPivotFieldList. This is the header of the window that is used for this dialog. The {0} is replaced by the name of the group description. Example: Filter Items (Product)
PivotFieldList_FormatFormat:Used in Number Format dialog of RadPivotFieldList as a label to show that the nearby TextBox is used to format the values in the cells.
PivotFieldList_FormatCellsP0Format Cells ({0})Used in Number Format dialog of RadPivotFieldList. This is the header of the window, that is used for this dialog. The {0} is replaced by the value of Pivot_AggregateP0ofP1. Example: Format Cells (Sum of Quantity)
PivotFieldList_GeneralFormatGeneral FormatUsed in Number Format dialog of RadPivotFieldList to mark the area where you are able to select string format for the cells.
PivotFieldList_IgnoreCaseIgnore CaseUsed in Label Filter dialog of RadPivotFieldList. This is the text of the checkbox, that marks if the value entered in the above TextBox and group names in RadPivotGrid should ignore uppercase/lowercase differences.
PivotFieldList_IndexIndexUsed in RadPivotFieldList drop-down button of aggregate functions and calculations dialog. It marks index calculation.
PivotFieldList_IsBetweenis betweenUsed in Value filter dialog of RadPivotFieldList. It is used in ComboBox inside the dialog, which selects how to use the value in the nearby numeric. When is between is selected, two numerics will be visible and the user can select range with them. Only groups which value is in the range will be visible.
PivotFieldList_IsGreaterThanis greater thanUsed in Value filter dialog of RadPivotFieldList. It is used in ComboBox inside the dialog, which selects how to use the value in the nearby numeric. When is greater than is selected, only groups with value higher than entered, will be visible.
PivotFieldList_IsGreaterThanOrEqualTois greater than or equal toUsed in Value filter dialog of RadPivotFieldList. It is used in ComboBox inside the dialog, which selects how to use the value in the nearby numeric. When is greater than or equal to is selected, only groups with value higher than entered or equal to it, will be visible.
PivotFieldList_IsLessThanis less thanUsed in Value filter dialog of RadPivotFieldList. It is used in ComboBox inside the dialog, which selects how to use the value in the nearby numeric. When is less than is selected, only groups with value less than entered, will be visible.
PivotFieldList_IsLessThanOrEqualTois less than or equal toUsed in Value filter dialog of RadPivotFieldList. It is used in ComboBox inside the dialog, which selects how to use the value in the nearby numeric. When is less than or equal to is selected, only groups with value less than entered or equal to it, will be visible.
PivotFieldList_IsNotBetweenis not betweenUsed in Value filter dialog of RadPivotFieldList. It is used in ComboBox inside the dialog, which selects how to use the value in the nearby numeric. When is not between is selected, two numerics will be visible and the user can select range with them. Only groups which value is not in the range will be visible.
PivotFieldList_LabelFilterLabel FilterUsed in drop-down buttons of RadPivotFieldList. This value indicates that a Label filter will be applied. When you select this option in the drop-down menu, a new dialog will be opened.
PivotFieldList_LabelFilterP0Label Filter ({0})Used in Label Filter dialog of RadPivotFieldList. This is the header of the window that is used for this dialog. The {0} is replaced by the name of the group description that will be filtered. Example: Label Filter (Product)
PivotFieldList_MoreAggregateOptionsMore Aggregate Options...Used in drop-down buttons of RadPivotFieldList. When this option is selected, a new dialog will be opened in which the user can select an aggregate function that will be used.
PivotFieldList_MoreCalculationOptionsMore Calculation Options...Used in drop-down buttons of RadPivotFieldList. When this option is selected, a new dialog will be opened in which the user can select calculation function that will be used.
PivotFieldList_MoreSortingOptionsMore Sorting Options...Used in drop-down buttons of RadPivotFieldList. When this option is selected, a new dialog will be opened in which the user can select how to sort RadPivotGrid.
PivotFieldList_NoCalculationNo CalculationUsed in calculation dialog of RadPivotFieldList to indicate that a calculation will not be applied.
PivotFieldList_NoResultNo ResultUsed in label filter dialog of RadPivotFieldList when input does not match values.
PivotFieldList_NumberFormatNumber FormatUsed in drop-down buttons of RadPivotFieldList. When this option is selected, a new dialog will be opened in which the user can select the string format of the numbers shown in RadPivotGrid.
PivotFieldList_PercentDifferenceFrom% Difference FromUsed in calculation dialog of RadPivotFieldList to indicate that for each value in RadPivotGrid a difference from another group (selected in the next ListBox) will be calculated and the value will be shown as percent.
PivotFieldList_PercentOf% OfUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will be shown as percent of another group (selected in the next ListBox).
PivotFieldList_PercentOfColumnTotal% of Column TotalUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will be shown as percent of Colum Total.
PivotFieldList_PercentOfGrandTotal% of Grand TotalUsed in drop-down buttons and calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will be shown as percent of the Grand Total.
PivotFieldList_PercentOfRowTotal% of Row TotalUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will be shown as percent of Row Total.
PivotFieldList_PercentRunningTotalIn% Running Total InUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will be shown as percentages. The value shown in each cell is calculated as a sum of its own value and all of the values above. This sum is presented as a percent of the total (the value in the last cell of the column). So the last cell will have value 100% in all cases.
PivotFieldList_PleaseRefreshThePivotPlease refresh the pivot.Used in the dialogs of RadPivotFieldList to indicate that in order to show the content of the dialog, a refresh of RadPivotGrid is necessary. This option may show only in cases when Defer Updates option is turned on.
PivotFieldList_RankLargestToSmallestRank Largest to SmallestUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will ranked and the largest one will be set to 1, the next to 2, etc..
PivotFieldList_RankSmallestToLargestRank Smallest to LargestUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will ranked and the smallest one will be set to 1, the next to 2, etc..
PivotFieldList_RefreshRefreshUsed in a button inside the dialogs of RadPivotFieldList. The button indicates that a Refresh is needed in order to show the content of the dialog. This button may became visible only when Defer Updates is set to true.
PivotFieldList_RelativeToNext(next)Used in calculation dialog of RadPivotFieldList. This item is visible in the second ListBox only for specific calculations (Difference from, % Difference From, etc.) and it marks that the values in RadPivotGrid will be shown as difference from the next group values.
PivotFieldList_RelativeToPrevious(previous)Used in calculation dialog of RadPivotFieldList. This item is visible in the second ListBox only for specific calculations (Difference from, % Difference From, etc.) and it marks that the values in RadPivotGrid will be shown as difference from the previous group values.
PivotFieldList_ReportFilterReport FilterUsed in RadPivotFieldList as a header of the area where FilterGroupDescriptions are added.
PivotFieldList_RowLabelsRow LabelsUsed in RadPivotFieldList as a header of the area where RowGroupDescriptions are added.
PivotFieldList_RunningTotalInRunning Total InUsed in calculation dialog of RadPivotFieldList to indicate that the values in RadPivotGrid will be calculated in the following way: the value shown in each cell is calculated as a sum of its own value and all of the values above. So the last cell will have the value of the Total (sum of all values).
PivotFieldList_SearchSearchUsed in label filter dialog of RadPivotFieldList.
PivotFieldList_SelectAll(Select All)Used in report filter dialog of RadPivotFieldList. When this option is selected, all items inside the dialog will be selected.
PivotFieldList_SelectItemSelect ItemUsed in report filter dialog of RadPivotFieldList to mark the area where you can choose which groups to see in RadPivotGrid.
PivotFieldList_SelectItemsSelect ItemsUsed in the drop-down button inside report filter box of RadPivotFieldList. When this option is selected, a new dialog will open.
PivotFieldList_SetAverageAggregateAverageUsed in the drop-down button inside Values filter box of RadPivotFieldList. When this option is selected, Average aggregate function will be applied to the values inside RadPivotGrid.
PivotFieldList_SetCountAggregateCountUsed in the drop-down button inside Values filter box of RadPivotFieldList. When this option is selected, Count aggregate function will be applied to the values inside RadPivotGrid.
PivotFieldList_SetIndexTotalFormatIndexUsed in the drop-down button inside Values filter box of RadPivotFieldList. When this option is selected, Index calculation will be applied to the values inside RadPivotGrid.
PivotFieldList_SetPercentOfGrandTotalFormat% of Grand TotalUsed in the drop-down button inside Values filter box of RadPivotFieldList. When this option is selected, the values inside RadPivotGrid will be shown as percent of the Grand Total.
PivotFieldList_SetSumAggregateSumUsed in the drop-down button inside Values filter box of RadPivotFieldList. When this option is selected, Sum aggregate function will be applied to the values inside RadPivotGrid.
PivotFieldList_ShowShowUsed in the Top 10 Filter dialog of RadPivotFieldList. It marks the area where users can select different options for the filter.
PivotFieldList_ShowEmptyGroupsShow Empty GroupsUsed in the drop-down button inside Rows and Columns boxes of RadPivotFieldList. When this option is selected, the empty groups will be shown in RadPivotGrid.
PivotFieldList_ShowSubTotalsShow SubtotalsUsed in the drop-down button inside Rows and Columns boxes of RadPivotFieldList. When this option is selected, the subtotals will be shown in RadPivotGrid.
PivotFieldList_ShowItemsForWhichShow items for whichUsed in Values filter dialog of RadPivotFieldList. It marks the area where users can select different options for the filter.
PivotFieldList_ShowItemsForWhichTheLabelShow items for which the labelUsed in Label filter dialog of RadPivotFieldList. It marks the area where users can select different options for the filter.
PivotFieldList_ShowValuesAsShow Values AsUsed in calculation dialog of RadPivotFieldList. It marks the area where users can select which calculation function to apply.
PivotFieldList_ShowValuesAsP0Show Values As ({0})Used as header of the calculation dialog of RadPivotFieldList. {0} is replaced by Pivot_AggregateP0ofP1 value. Example: Show Values As (Sum of Quantity)
PivotFieldList_SortAtoZSort A to ZUsed in drop-down menu of buttons inside Rows and Columns boxes of RadPivotFieldList. When this option is selected, ascending order is applied.
PivotFieldList_SortOptionsSort optionsUsed in sorting dialog of RadPivotFieldList. It marks the area where users can select what kind of sorting to apply.
PivotFieldList_SortP0Sort ({0})Used as header of the sorting dialog in RadPivotFieldList. {0} is replaced by the property name that is used. Example: Sort (Product)
PivotFieldList_SortZtoASort Z to AUsed in drop-down menu of buttons inside Rows and Columns boxes of RadPivotFieldList. When this option is selected, descending order is applied.
PivotFieldList_StringFormatDescriptionThe format should identify the measurement type of the value. The format would be used for general computations such as Sum, Average, Min, Max and others.Used inside Number Format dialog of RadPivotFieldList. This is the description what can be achieved via the dialog.
PivotFieldList_SummarizeValuesBySummarize Values ByUsed in a dialog of RadPivotFieldList where the user can change the aggregate function. It marks the area where users can select which function to apply.
PivotFieldList_TheActionRequiresMoreRecentInformationThe action requires more recent information.Used in the dialogs of RadPivotFieldList to indicate that in order to show the content of the dialog, additional information is needed. It is combined with the value of PivotFieldList_PleaseRefreshThePivot to indicate that Refresh of RadPivotGrid is necessary. This option may show only in cases when Defer Updates option is turned on.
PivotFieldList_Top10FilterP0Top10 Filter ({0})Used as header of the Top 10 filter dialog in RadPivotFieldList. {0} is replaced by the property name that is used. Example: Top10 Filter (Product)
PivotFieldList_Top10ItemsItemsThis value is used inside Top 10 Filter dialog of RadPivotFieldList. It is one of the options in the ComboBox, in which the user can select if the filter should be on Items, Percent or Sum. When this option is selected, user can show specific number of groups in RadPivotGrid - for example Top 10 groups by Sum of Quantity.
PivotFieldList_Top10PercentPercentThis value is used inside Top 10 Filter dialog of RadPivotFieldList. It is one of the options in the ComboBox, in which the user can select if the filter should be on Items, Percent or Sum. When this option is selected, user can show specific percent of groups in RadPivotGrid - for example Top 10 percent by Sum of Quantity.
PivotFieldList_Top10SumSumThis value is used inside Top 10 Filter dialog of RadPivotFieldList. It is one of the options in the ComboBox, in which the user can select if the filter should be on Items, Percent or Sum. When this option is selected, user can show groups, which summarize to a specific sum - for example Top 100 Sum by Sum of Quantity.
PivotFieldList_TopItemsTopThis value is used inside Top 10 Filter dialog of RadPivotFieldList. It is one of the options in the ComboBox, where the user can select if the Top or Bottom results of applied filter will be shown. When this option is selected, the Top results will be shown.
PivotFieldList_TopTenFilterTop 10 FilterUsed in drop-down menu of buttons inside Rows and Columns boxes of RadPivotFieldList. When this option is selected, a new dialog will be opened, where the user can apply Top 10 filter.
PivotFieldList_UpdateUpdateUsed as a content of a button inside RadPivotFieldList. When the button is clicked, RadPivotGrid is refreshed. The button is enabled only when Defer Updates is set to true.
PivotFieldList_ValueFilterValue FilterUsed in drop-down menu of buttons inside Rows and Columns boxes of RadPivotFieldList. When this option is selected, a new dialog will be opened, where the user can apply Value filter.
PivotFieldList_ValueFilterP0Value Filter ({0})Used as a header of the Value Filter dialog of RadPivotGrid. {0} is replaced by the property name that is used. Example: Value Filter (Product)
PivotFieldList_ValueSummarizationP0Value Summarization ({0})Used as a header of the aggregate description dialog of RadPivotGrid. {0} is replaced by Pivot_AggregateP0ofP1 value. Example: Value Summarization (Sum of Quantity)
PivotFiledList_ValuesValuesUsed in RadPivotFieldList. This is the header of the box in which are the aggregate descriptions.
PivotFieldList_Null(null)Appears in the "Select Items" dialog for properties with null value.
Pivot_HourGroup{0} - HourUsed as a DisplayName of the Hour Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Hour
Pivot_MinuteGroup{0} - MinuteUsed as a DisplayName of the Minute Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Minute
Pivot_SecondGroup{0} - SecondUsed as a DisplayName of the Second Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Second
Pivot_DayGroup{0} - DayUsed as a DisplayName of the Day Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Day
Pivot_WeekGroup{0} - WeekUsed as a DisplayName of the Week Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Week
Pivot_MonthGroup{0} - MonthUsed as a DisplayName of the Month Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Month
Pivot_QuarterGroup{0} - QuarterUsed as a DisplayName of the Quarter Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Quarter
Pivot_YearGroup{0} - YearUsed as a DisplayName of the Year Step of a Field with DateTime dataType. {0} is replaced by the property name that is used. Example: ShippingDate-Year
Pivot_CalculatedFieldsCalculated FieldsUsed as a DisplayName of the Calculated Fields folder in the field list.
PivotFieldList_ItemFilterConditionCaptionShow items with value thatUsed as caption of the label filter condition in the Label Filter dialog of a group description.
PivotFieldList_NoneData source orderUsed as a content of a RadioButton in the More Sorting Options dialog of a group description.
PivotFieldList_Sort_BySortKeysby Sort KeysUsed in the More Sorting Options dialog of a group description when data provider is OLAP Cube.
PivotInlineFieldList_RowsEmptyTextDrag row items hereUsed in the inline RadPivotFieldList as a header of the area where RowGroupDescriptions can be added.
PivotInlineFieldList_ColumnsEmptyTextDrag column items hereUsed in the inline RadPivotFieldList as a header of the area where ColumnGroupDescriptions can be added.
PivotInlineFieldList_ValuesEmptyTextDrag data items hereUsed in the inline RadPivotFieldList as a header of the area where AggregateGroupDescriptions can be added.
PivotInlineFieldList_FiltersEmptyTextDrag filter items hereUsed in the inline RadPivotFieldList as a header of the area where FilterDescriptions can be added.
PivotInlineFieldList_FieldChooserField ChooserThe title displayed for the field chooser dialog.
PivotInlineFieldList_FieldsDrag fields in the inline field list:The label prompting the user to drag the fields displayed in the field chooser dialog.
PivotInlineFieldList_SortSortThe header for the sort operation in the field context menu.
PivotInlineFieldList_RemoveRemoveThe header for the remove operation in the field context menu.
PivotInlineFieldList_ReloadDataReload DataThe header for the operation of reloading data in the field context menu.
PivotInlineFieldList_ShowFieldListShow Field ListThe header for the menu item responsible for showing the field chooser dialog.

See Also

In this article
Supported LanguagesLocalization Using Custom Localization ManagerSee Also
Not finding the help you need?
Contact Support