Copied from AOO bugzilla https://bz.apache.org/ooo/show_bug.cgi?id=126718 Forum topic: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=80635 The attached spreadsheet tries to resolve the problem by appending a calculated field =ISBLANK($C2) to the source table. The only the FALSE values are reflected in the pivot table. Surprisingly, turning the boolean into a text field with 2 categories =IF(ISBLANK($C2);"Yes";"No") makes no difference. Only the "No" values will aggregate. Conversion of formulas to two constant values makes no difference. The aggragation works when there are more than two different values. The attached file contains a source table, a wanted result and a pivot sheet with 2 pivots, one where the aggregation of a boolean field fails and another one where the aggregation of 3 values works.
Created attachment 121010 [details] Data and 2 pivot tables
Created attachment 121014 [details] Sample file adding one more field to count. Hi @Andreas, seems that what are not counted are the empty cells of "PC" field, instead use "PC" using another field to count, can be counted. I'm not sure the second one works their total is also 103. Must be empty cells counted?
Ouch! You got me. Of course it can not count empty PC. I have chosen an inadequate data field.
Thanks for the confirming. Closed as not a bug, please if you are not agree reopen it.