Hello

I am stuck in a wierd situation. I have a data, with which I creates a Pivot. Some of the value coming in Pivot are Zero, however some of those Zeros are though displayed as Zero, but when I press F2 to go into that cell they have values like 4,54747350886464E-13 or 2,27373675443232E-13.

My problem is that, I need to create a filter to remove all Zeros from that pivot, but as they are written in scientific notation, I am unable to filter all ZERO from my data. Please can some one help.

Regards
Gaurav

On Fri, 17 May 2013 07:50:22 +0100, Gaura215 wrote:


Hello

I am stuck in a wierd situation. I have a data, with which I creates a
Pivot. Some of the value coming in Pivot are Zero, however some of those
Zeros are though displayed as Zero, but when I press F2 to go into that
cell they have values like 4,54747350886464E-13 or 2,27373675443232E-13.


My problem is that, I need to create a filter to remove all Zeros from
that pivot, but as they are written in scientific notation, I am unable
to filter all ZERO from my data. Please can some one help.

Regards
Gaurav

For the formulas that create those values, you could round them to the desired level of precision.
You could filter on a small value that is within your desired precision.
You could set Precision as Displayed as an option, but this is rarely recommended as it is a workbook-wide option, and can have deleterious effects if you require greater precision in your calculations than you would like to display.