Category / Section
How to display discrete value in Numerical format
It can be achieved by tweaking the existing functionality of “DisplayIfDiscreteValueEqual”. i.e., Now the SummaryType “DisplayIfDiscreteValueEqual” is forced to work for both numeric (Ex: 999) and string (special character Ex: ***) .The following code snippet explains the same.
C#
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo()
{
FieldName = "TestDouble",
FieldHeader = "TestDouble",
Format = "0.000",
SummaryType = SummaryType.DisplayIfDiscreteValuesEqual,
PadString = "999",
AllowFilter = true,
AllowSort = true
});
