Hey all,

I'm using a claculted field in my pivot table, with formula
=if(iserror(Bugid/Bugid),0,1). the field functions well, but all the
subtotals show 1, instead of the real sum of the calculated field results.
it look something like

Column1 calc.field.count
X 1
0
1
X subtotal 1

Y 0
Y subtotal 0

Z 1
Z subtotal 1

of course that X subtotal should be 2.

all the grand subtotals are also 1 / 0, with no higher values