Description: I have a pivot table coming from a large table. I am using the filter option when creating the pivot table, and when I click the Filter button on the pivot table itself, I can create a criteria for filtering a large amount of data, but the criteria itself is NOT showing on the pivot table, nor a sign that the data is filtered (like a caption). I am not refering to the buttons with small black triangles because these ones turn to blue-with-dot when some filtering is made. I mean the left-uppermost button named Filter on the pivot table. This is NOT a bug, but a feature request. My intentions is to show off the criteria that I am using when filtering a pivot table, so someone else will be aware of the filtering I am performing. Steps to Reproduce: 1.Create a table with three columns and 20 rows (i.e. Text, Date, Amount columns, and generated values to populate the table) 2.Create a pivot table out of it, just showing the Date as rows labels, and Sum-Amount as other column) 3.Filter the pivot table using «Text<>'R'» as criteria Actual Results: You see the Filter bitton, but NO indication/caption/message of what criteria is being used as filter Expected Results: To see «Text<>'R'» on the next cell, close to the Filter button (left-upper corner of the pivot table) Reproducible: Always User Profile Reset: No Additional Info: I asked this feature in AskLibreOffice, and Lupp suggested this should be a feature request. https://ask.libreoffice.org/en/question/128068/visible-criteria-when-filtering-a-pivot-table/ User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36
(In reply to lobaluna from comment #0) > Steps to Reproduce: > 1.Create a table with three columns and 20 rows (i.e. Text, Date, Amount > columns, and generated values to populate the table) > 2.Create a pivot table out of it, just showing the Date as rows labels, and > Sum-Amount as other column) Even thought this is a feature request, please attach such an example file. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 136235 [details] A small example of the feature requested This snmall example show how a caption of the criteria used to filter the Pivot Table would clarify the data shown.