Hi,

When try to sort a column that has NA values and also numeric values in it,

it fires an exception that cannot compare it to double, so how can i resolve it? or at least what to write in the   pivotGrid_ColumnSorting(object sender, PivotSortingCancellableEventArgs e)

 function to catch the exception when the value of the cell is "NA"

Thanks,

nharake