https://bz.apache.org/ooo/show_bug.cgi?id=126718
--- Comment #3 from Andreas Säger <[email protected]> --- (In reply to oooforum from comment #2) > Calculated field ability is already reported with issue 89477 > So maybe a duplicate? Issue 89477 is an enhancement request for calculated fields as implemented in MS Excel since 1997 where you can define a calculated field without touching the source table. When calculated fields can not be defined for the pivot table, one has to implement them in the source table which is what I did in column D of the attached example file. But then the pivot table fails to evaluate this field. The problem is not the calculation of the source table field. You can convert the field to constant values and get the same failure in the pivot table. You can convert the boolean values to strings or any other pair of numbers and get the same failure in the pivot table. BUT if you add a field with more than 2 variations [try =RANDBETWEEN(1;3)], the pivot works as expected. -- You are receiving this mail because: You are the assignee for the issue.
