In pivot table how to do average for the cells which contains 0.
pivotTable.DataFields.Function = ConsolidationFunction.Average;
I am getting Div/0 Error ..
Well, I think this is now MS Excel works or calculates for 0/0 values. How could you do this (to fix div error (“0” or null instead of div error) for pivot table report data) to automatically perform your task. If you know, do let us know with template file we will check it soon.