Add slicers to Pivot table in Calc
Steps to Reproduce:
1. Just try to use it in the Excel
2. Then add it into Calc
There isn't slicers functional in Calc
There is slicers functional in Calc
User Profile Reset: No
Slicers will help you:
1. Filter many parameters in Pivot table or in Pivot chart without manual changing of Pivot table fields
2. Control several Pivot tables/Pivot charts from one slicer
3. Have opportunity to very fast re-customize view of data in your Pivot tables/Pivot charts
You have several slicers for one huge Pivot table with many initial datas.
It is really super feature, that can help you increase convenience of using of Pivot table/Pivot chart
OK -> NEW
I think there is difference in slices for Pivot tables and one for tables. Is that correct?
(In reply to Cor Nouws from comment #4)
> I think there is difference in slices for Pivot tables and one for tables.
> Is that correct?
I don't know about slicers for tables. I used it only for Pivot tables
*** Bug 122475 has been marked as a duplicate of this bug. ***
*** Bug 134083 has been marked as a duplicate of this bug. ***
Let's use this enhancement request both for tables and pivot tables. I don't know if/how much they differ, if anyone has details, do chime in.
It is important to add the slicer functionality not only for Pivot Tables, but also for user-defined tables on a single spreadsheet. It would work as a simplified filtering functionality, making the spreadsheet more dynamic.
Today LO Calc can't import .xlsx files that contain slicers on tables.
Maybe the slicer functionality would entail the development of other features such as "Format as Table" (similar to MS Excel).
(In reply to Aron Budea from comment #8)
> Let's use this enhancement request both for tables and pivot tables. I don't
> know if/how much they differ, if anyone has details, do chime in.
I believe the implementation of slicers for tables is much simpler that on Pivot Tables.
On tables it would function as a simplified filtering device. In my opinion, the workflow could be as follows:
1 - The user selects a range containing a table (with column headers) and define it as being a table (hence the "Format as Table")
2 - On the "Data" tab, a button "Insert Slicer" would appear if the spreadsheet has a table
3 - The user would be able to insert Slicers for the columns he/she desires
4 - The slicer would contain buttons with each single value in that column; then the user would be able to filter the table by clicking these buttons
I uploaded an image slicer_calc.png to give an idea of what I am talking about.
Created attachment 162131 [details]
Overview of the slicer functionality