Description: Not the same as Bug 108834 which claims a failure when the filter is set to show ONLY empty cells. This is the exact opposite. When deselecting empty values they are still shown so there is no effective way to simply show the first level Steps to Reproduce: Create a data table with perhaps four columns Column 1 is a name - ensure you have more than one name Column 2 is a category - ensure you have more than one category Column 3 is a date - ensure you have a busy diary Column 4 is a sum of money - ensure you spend loads of dough on your date ;) Perhaps even get a refund so there are some credits as well as debits Create the pivot table with columns 1, 2 & 3 as the Row Fields: entries and column 4 as the Data Fields: summed entry. Ensure your PT display includes blank spaces in columns 1 & 2 Try to exclude blanks by deselecting the blanks check box in the column filter on column 1 or 2 Actual Results: Screen full of empty cells and every value is shown Expected Results: Whichever column has been selected to exclude blanks should exclude the blanks but far more importantly it should produce a sub total for the appropriate consolidation of column 1, 2 & 3 items. Therefore, if you date the same companion on multiple occasions at many of the places you attend then there should be appropriate subtotals at the day level, the venue level and the companion level. Of course, if you prefer to sell different groceries from different market stalls on different days for variable sums of money you would probably still want the same subtotals. If I tell a PT filter to not display an empty item it means the same as in an ordinary filtered array - I don't care what is further along the line exclude it AND ensure the appropriate subtotals are maintained. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.3.5.2 (x64) / LibreOffice Community Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 182472 [details] Screen Dump As can be seen, the filter to exclude all blanks had been activated but all the blank lines in that column are still visible. I would expect it to collapse all the blank rows in that column and produce sub-totals as appropriate - just like a pivot table would. In this guise, it's more like an inferior Autofiltered array without the benefit of SUBTOTAL() to include or exclude values in the "hidden" rows. A pivot table should of course consolidate the values into subtotals at the appropriate levels of collapse.
(In reply to Colin from comment #0) > Steps to Reproduce: > Create a data table with perhaps four columns > Column 1 is a name - ensure you have more than one name > Column 2 is a category - ensure you have more than one category > Column 3 is a date - ensure you have a busy diary > Column 4 is a sum of money - ensure you spend loads of dough on your date ;) > Perhaps even get a refund so there are some credits as well as debits > Create the pivot table with columns 1, 2 & 3 as the Row Fields: entries and > column 4 as the Data Fields: summed entry. > > Ensure your PT display includes blank spaces in columns 1 & 2 Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 185088 [details] Sample pivot table Try to exclude the EMPTIES with the filter on column 1 "Name" Observe that nothing changes all the empties are still producing values in columns 2,3 & 4 Exclude or re-include any of the other Names in column 1 and observe how the other columns respond approriately. I would expect a subtotal anywhere there are groups say "tender" or "Juicy"
Hello Colin, Thank you for reporting the bug. I can confirm that the bug is present in master. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d9031bd83ffe718a80da9ecbdbeb485e35fbabee CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded