H
Hans Knudsen
Hello
In a pivot table I have a calculated field with a formula like this: =Estimate2 - Estimate1. A lot of the items in this calculated
field is 0. Question: How can I automatically hide all these rows?
I am aware of the Table Options dialog box and the "For empty cells,
show", but this doesn't seem to work in a calculated field.
If possible I want to avoid having the calculation of Estimate1-Estimate2 in my data range.
Hans Knudsen
In a pivot table I have a calculated field with a formula like this: =Estimate2 - Estimate1. A lot of the items in this calculated
field is 0. Question: How can I automatically hide all these rows?
I am aware of the Table Options dialog box and the "For empty cells,
show", but this doesn't seem to work in a calculated field.
If possible I want to avoid having the calculation of Estimate1-Estimate2 in my data range.
Hans Knudsen