Hi
In pivot table how to do average for the cells which contains 0.
pivotTable.AddFieldToArea(PivotFieldType.Data, 3);
pivotTable.DataFields[2].Function = ConsolidationFunction.Average;
I am getting Div/0 Error ..
In pivot table how to do average for the cells which contains 0.
pivotTable.AddFieldToArea(PivotFieldType.Data, 3);
pivotTable.DataFields[2].Function = ConsolidationFunction.Average;
I am getting Div/0 Error ..
I understand that 0/0 in Average is giving error.
I dont want display Div/0 Error in pivot table.
Instead of error .. I want to show a null value or 0 ..
Please help me ..
Thanks,
jack