Category / Section
How to display discrete value in Numerical format
1 min read
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
});
